Change the Row Colour, using a cell condition
 

Is it possible to change the colour of a row (to say light gray) when a
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 row
changes colour to say gray or any colour ....

Hope you can help me on this.

Cheers


--
belgarth58
------------------------------------------------------------------------
belgarth58's Profile: http://www.excelforum.com/member.php...o&userid=31280
View this thread: http://www.excelforum.com/showthread...hreadid=509481

Change the Row Colour, using a cell condition
 

Select the entire row, say 12, FormatConditional 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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=509481