Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kierano - 20 Oct 2006 14:11 GMT

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 are:

=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.

Reply to this Message

PCLIVE - 20 Oct 2006 14:32 GMT

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

> Hi,
>
[quoted text clipped - 20 lines]
>
> Thanks in advance for your help.

Reply to this Message

Sandy - 20 Oct 2006 14:34 GMT

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

> Hi,
>
[quoted text clipped - 16 lines]
>
> Thanks in advance for your help.

Reply to this Message