Conditional formatting Help!
 

Hi,

I've got a problem with conditional formatting.

3 conditions

=$AO88<=10

=AND($AO8810,$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



--
Mifty

Conditional formatting Help!
 

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

=AND($AO880,$AO88<=10)

Hope this helps.

Pete

On Mar 11, 12:29*am, Mifty wrote:
Hi,

I've got a problem with conditional formatting.

3 conditions

=$AO88<=10

=AND($AO8810,$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

--
Mifty

Conditional formatting Help!
 

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
--
Mifty


"Pete_UK" wrote:

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

=AND($AO880,$AO88<=10)

Hope this helps.

Pete

On Mar 11, 12:29 am, Mifty wrote:
Hi,

I've got a problem with conditional formatting.

3 conditions

=$AO88<=10

=AND($AO8810,$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

--
Mifty

Conditional formatting Help!
 

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

On Mar 11, 12:01*pm, Mifty wrote:
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
--
Mifty



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

=AND($AO880,$AO88<=10)

Hope this helps.

Pete

On Mar 11, 12:29 am, Mifty wrote:
Hi,

I've got a problem with conditional formatting.

3 conditions

=$AO88<=10

=AND($AO8810,$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

--
Mifty- Hide quoted text -

- Show quoted text -