conditional format problem John <JOhn6328[ at ]mchsi.com> 15.07.2006 16:25:47 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

Re: conditional format problem "RagDyeR" <ragdyer[ at ]cutoutmsn.com> 15.07.2006 16:45:03 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" <JOhn6328[ at ]mchsi.com> wrote in message news:exX2UtCqGHA.524[ at ]TK2MSFTNGP05.phx.gbl... 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

Re: conditional format problem SteveW <sj_walton[ at ]nothotmail.com> 15.07.2006 18:40:46 On Sat, 15 Jul 2006 17:25:47 +0100, John <JOhn6328[ at ]mchsi.com> wrote: [Quoted Text] > I have two conditions > 1. m2>0 > 2. =3DM2-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=3D0. Why? > > John -- = Steve (3)

Re: conditional format problem John <JOhn6328[ at ]mchsi.com> 16.07.2006 16:00:53 RagDyeR wrote: [Quoted Text] > 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

Re: conditional format problem "Ragdyer" <RagDyer[ at ]cutoutmsn.com> 16.07.2006 16:23:26 Appreciate the feed-back. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "John" <JOhn6328[ at ]mchsi.com> wrote in message news:OPQXEEPqGHA.5108[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > 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