Dear all,

I am attempting to set up a template for someone else to use on another
machine, and wish conditional format a cell such that it has four
potential formats.

The first is based on an adjacent cell value, and if this is met, then
it is colour 1.
The remaining three, are all AND statements involving the first cell
and another cell value being less than date A, less than date B or less
than date C.

Is this possible to do? I have limited VB knowledge, and am wary of
using add-ins as the people I am sending this to to use have limited
excel knowledge.

Regards,

Steve


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