Excel - Color row based on a Value

Excel - Color row based on a value


In Excel we will at times like to have the row colored automatically based on the values entered in the cell.

For example when the states is entered as Closed we would like to have the full row colored in Green.

 

 This effect can be achieved using Conditional Formatting in Excel 2007.

• Select the row (All columns) which need the coloring effect.
• Select the Home Tab and click Conditional Formatting
• In the options select ManageRules 
• Click New Rule 
• Select the option Use a formula to determine which cells to format 
• In the TextBox enter formula which will determine the Color (=$E4="WorkInProgress")
• Click on the Format button and select the color to be applied to the Row
• Click Ok

 Now enter the specific values in the Cell and you can see that the color of the row has changed automatically.

In this case entering the value WorkInProgress in the cell E4 will change the color of the Row.