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