Conditional formatting Help!

M

Mifty

Hi,

I've got a problem with conditional formatting.

3 conditions

=$AO88<=10

=AND($AO88>10,$AO88<20)

=$AO88>=20

My problem is that blank cells are being formatted as for condition 3 and I
don't want it to be!!

Any help would be truly appreciated

Cheers
 
P

Pete_UK

A blank cell is treated as zero, so it will match your first condition
- change it to:

=AND($AO88>0,$AO88<=10)

Hope this helps.

Pete
 
M

Mifty

Hi Pete,

Thanks for your reply. I've used your formula but changed it 'cos it was the
third condition that was giving me problems. AO is the abs difference between
two values max of 100 each so:

=AND($AO9<100,$AO9>=20)

This works fine but why and what would I do if I didn't have a ceiling
figure I could put in?

Cells are formatted as numbers

Thanks again
 
P

Pete_UK

If AO is the abs difference between two other cells, and one of them
is zero (blank cell), then the difference could be up to 100, so that
is why your third condition is applied. I don't know anything about
what you are trying to do, but you could control the value in AO with
something like this:

=IF(OR(x="",y=""),"",ABS(x-y))

where x and y are your two cells whose difference you want.

Hope this helps.

Pete
 
Top