for cells B7 to B12, set the conditional format to something like ...

Condition 1.
Formula.
=if(C7="Y",1,0)
Then set the colours accordingly.

Condition 2.
Formula.
=if(C7="N",1,0)
Then set the colours accordingly.

Hope I've understood correctly and this helps.


--
tonywig


------------------------------------------------------------------------
tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=389006