conditional format problem

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have two conditions
1. m2>0
2. =M2-P2<3

It only pays attention to the 2nd condition. As if its and "or" rather
than an "and".

I'm using conditional formating off the toolbar.

I want to color the cell red if both conditions are met. It works fine
if m2> 0 but it also works if m2=0. Why?

John
 
Are you using:
"Formula Is"
And this formula:

=AND(M2>0,M2-P3<3)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have two conditions
1. m2>0
2. =M2-P2<3

It only pays attention to the 2nd condition. As if its and "or" rather
than an "and".

I'm using conditional formating off the toolbar.

I want to color the cell red if both conditions are met. It works fine
if m2> 0 but it also works if m2=0. Why?

John
 
I have two conditions
1. m2>0
2. =M2-P2<3

It only pays attention to the 2nd condition. As if its and "or" rather
than an "and".
Click to expand...

they are independent, so it's neither or nor and if you know what I mean:)
 
RagDyeR said:
Are you using:
"Formula Is"
And this formula:

=AND(M2>0,M2-P3<3)
Click to expand...
No, I wasn't and that worked... thanks. I was using the tiered selction
process from the tool bar.

John
 
Back
Top