Please help me on Color code
 

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

Please help me on Color code
 

Hi Jane

You can use CF

See Debra's site for a example
http://www.contextures.com/xlCondFormat01.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"anil" wrote in message ups.com...
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

Please help me on Color code
 

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)


"anil" wrote:

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