Change the Row Colour, using a cell condition

[belgarth58]

Is it possible to change the colour of a row (to say light gray) when
condition has been reached in a cell on that row ???


Example, if a cell has a Yes/No, and when you select yes, the whole ro
changes colour to say gray or any colour ....

Hope you can help me on this.

Cheer

 

[SteveG]

Select the entire row, say 12, Format>Conditional Formatting

Change from Cell Value Is to Formula is. If F12 is where your Yes/No
is then

=$F$12="Yes"

Select the formatting you want by selecting "Format". Select OK.
Select OK again.



HTH

Steve