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.