Excel - Conditional formatting for an entire row

October 2016


I'm trying to set up a conditional formatting based on the TEXT value of a cell and I want the row to change color if the particular cell has a value = YES or NO
How do I go about setting that up?


Select the rows and apply the conditional formatting as

Like in example below I want each row in the sheet to turn use conditional formatting if in the corresponding value in B column of that row is "YES"

So I selected all the cells, and went to the conditional formatting and applied this formula


And change the color to red


Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Excel - Conditional formatting for an entire row » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.