Conditional formatting
You need to make the 0 condition your first condition. If you have it as
your last condition, and A45 was zero and B45 was 12, then the condition of
A45=MAX(A45:B45) will be met first.
Condition 1:
=A45=0
Condition 1:
=B45=MAX(A45:B45)
Condition 1:
=A45=MAX(A45:B45)
HTH,
Paul
"Kierano" wrote in message
...
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.
|