Excel - Conditional formatting for an entire row

March 2018


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.
Published by aakai1056. Latest update on February 16, 2010 at 02:21 AM by aakai1056.
This document, titled "Excel - Conditional formatting for an entire row," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Automatically change text in column
Excel - Delete rows with same value