On Oct 19, 10:51*am, "Peter T" <peter_t@discussions wrote:
"Paul Black" wrote in message

"
Thanks for the reply Peter T.
What I basically need is for ...

Condition 1, if the cell is greater than zero or blank for it to be a
grey background.
Condition 2, if the cell is greater than zero or blank and complies
with =IF(OR(S22=$W$5,S22=$X$5,S22=$Y
$5,S22=$Z$5,S22=$AA$5,S22=$AB$5),S22) for the background to be blue..
Condition 3, if the cell is greater than zero or blank and complies
with =IF(S22=$AC$5,S22) for the background to be Red.
"

CFs 2 & 3 will never kick in because CF1 will already have been applied on
the basis of "greater than zero or blank" (btw simply *=0 or "greater than
or equal to: 0").

Sounds like you want to reorder your CFs. Decide which of CF2 or 3 has
priority and make that the first CF, and change what is currently CF1 to
CF3.

Alternatively, make the default format same as current CF1 format, ie assume
all values will be *=0 (blank evaluates to zero). Change CF1 to "less than:
0" with the current default format. CFs 2 & 3 can remain pretty much as they
are but you can remove the =0 check (handled by CF1's <0 check). That
should make things simpler.

Regards,
Peter T

Thanks for the help Peter I have now sorted it,

Regards,
Paul