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