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!
=====================================================

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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

On Sat, 15 Jul 2006 17:25:47 +0100, John <(E-Mail Removed)> wrote:

> 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".

they are independent, so it's neither or nor and if you know what I mean
>
> 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



--
Steve (3)

RagDyeR wrote:

> Are you using:
> "Formula Is"
> And this formula:
>
> =AND(M2>0,M2-P3<3)
>
No, I wasn't and that worked... thanks. I was using the tiered selction
process from the tool bar.

John

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> RagDyeR wrote:
>
> > Are you using:
> > "Formula Is"
> > And this formula:
> >
> > =AND(M2>0,M2-P3<3)
> >
> No, I wasn't and that worked... thanks. I was using the tiered selction
> process from the tool bar.
>
> John