colour text in validation lists
 

Hi,
I have a number of columns where all cells have a simple validation
list (YES,NO). What I would like to do is have a code whereby I can
colour a particular response when it is entered. i.e. YES colour =
Green. NO colour = Red. This will allow me to quickly scan for any
highlights.....anyone have any solutions?
thanks,
Dario :)


--
Dario
------------------------------------------------------------------------
Dario's Profile: http://www.excelforum.com/member.php...o&userid=24597
View this thread: http://www.excelforum.com/showthread...hreadid=381872

colour text in validation lists
 

Select all the cells you want this feature for. Go to Format
Conditional Formatting.
Add your conditions, something like if select equal to, enter "Yes" i
box, click on format button to select a color, either for the cell, o
the font. Add another for No.

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38187