thanks for your help anyway but youve not quite grassped what i was
after.
column a = apple _and_ column b is either green _or__yellow.
--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread:
http://www.excelforum.com/showthread...hreadid=513151