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