Exactly, well discovered.

Bob


"cjrrussell" wrote
in message ...

Ahh i have done it

You have to set 2 conditions for the cell

1 says if equal to yes make it this colour

the other says if equal to no make it this colour

Thanks for your help


--
cjrrussell
------------------------------------------------------------------------
cjrrussell's Profile:
http://www.excelforum.com/member.php...o&userid=19788
View this thread: http://www.excelforum.com/showthread...hreadid=491828