Thanks Ola,

However the reference to the other cells part is the element that I
have resolved. It is the fact that I would like four different options
available to me through conditional formatting that is proving to be
the problem.

Any ideas anyone?

Steve


--
stevepain
------------------------------------------------------------------------
stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759
View this thread: http://www.excelforum.com/showthread...hreadid=390557