Conditional formatting
 

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.

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.

Conditional formatting
 

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.