Please help me on Color code

A

anil

Hi all,

I have a choice list of yes and no, when i select yes the cell should
be green and when no it should be red.

Anil hungund
 
J

John

have a look at conditional formatting setting cell value to be wither yes or
no and format accordingly
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Top