View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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.