Four Conditional Formats?

S

stevepain

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
 
S

stevepain

Thanks Ola,

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

Any ideas anyone?

Stev
 
S

stevepain

Ola,

OK, thanks for your help, I suspected the answer to be as much, and
will look into the three options you provided.

However, in the mean time, I think I've come up with a crude solution -
the cell format can be set to option number 1 through format cells. The
remaining three options can be set through conditional formating. If
none of the conditional formatting criteria are met, then it defaults
to the original formatting as set through format cells.

Thus 4 different formats are possible.
 
Top