Try putting your 3rd condition first. Conditional formatting finds the
first "True" value in the contitions and then stops, so since 0 might
be the max for your range a true value will result in condition1 and
will never get to condition 3.

HTH

Sandy


Kierano wrote:
Hi,

I want to turn one cell green (f45) based on another cell (a45) having a
zero in it.

Seems simple enough, and I thought it would be as straightforward as:

=a1=0

I should also mention that this is condition 3. The first 2 conditions a

=A45=MAX(A45:B45) format is red
=B45=MAX(A45:B45) format is blue

The reason I need a third condition is that sometimes the source cells will
have zeroes in, so I need this to be reflected as a colour other than those
used for conditions 1 and 2, as excel is currently returning a format of red
for source cells with zero in.

Thanks in advance for your help.