In this tutorial, I will show you how to highlight rows based on a cell value using conditional formatting using different criteria.
This can easily be done using conditional formatting in Excel.
I cover the following examples in this video
— Highlight rows based on the text value
— Hight rows based on number value or date value
— Highlight rows that have blank cells in it
— Highlight rows based on multiple conditions
The technique here uses conditional formatting formula that checks each cell and applies the format if the result is TRUE and does not apply the format if the result is FALSE
You can read more about this and download the example file from here: https://ift.tt/2BCBIWL
-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:
-~-~~-~~~-~~-~-
Let’s Connect:
Google+ ► https://ift.tt/2jWiOzU
Facebook ► https://ift.tt/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► https://ift.tt/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel