I want to fill the cell color based upon the other cell condition

Hi,
Im trying to fill the cell color based upon the other cell conditions. Is
there anyway i can use the forumalas for this.
For Eg.
(if(a2-b2)> 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
e2=30)then f2=blue else f2=nofill)

Use Conditional Formatting with a formula of

=AND(A2-B2>15,E2=50)

for one condition, and

=AND(A2-B2>15,E2=30)

for a second

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sri" <sri@discussions.microsoft.com> wrote in message
news:354EE58D-A385-46AF-942A-B644EA483B9D@microsoft.com...
> Hi,
> Im trying to fill the cell color based upon the other cell conditions. Is
> there anyway i can use the forumalas for this.
> For Eg.
> (if(a2-b2)> 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
> e2=30)then f2=blue else f2=nofill)

I'm assuming that in your second condition, where you posted <<<"(a2-b2) ,15
">>>
You really meant >15, same as your first condition.

Click in F2, then:

<Format> <ConditionalFormat>,
Change "Cell Value Is" to
"Formula Is",
and enter this formula in the box to the right:

=AND(A2-B2>15,E2=50)

Then, click on <Format>
And choose Red for your Pattern, then <OK>,

Now, click on <Add>, to set your second condition.
Change "Cell Value Is" to
"Formula Is",
and enter this formula in the box to the right:

=AND(A2-B2>15,E2=30)

Then, click on <Format>
And choose Blue for your Pattern, then <OK> <OK>

--
HTH,

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



"sri" <sri@discussions.microsoft.com> wrote in message
news:354EE58D-A385-46AF-942A-B644EA483B9D@microsoft.com...
> Hi,
> Im trying to fill the cell color based upon the other cell conditions. Is
> there anyway i can use the forumalas for this.
> For Eg.
> (if(a2-b2)> 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
> e2=30)then f2=blue else f2=nofill)

Thanks a lot to both of you.
I have got one more questio. I think with this, i can give maximum of three
condition only. If I want to give more, how best i can proceed with this.

"Bob Phillips" wrote:

> Use Conditional Formatting with a formula of
>
> =AND(A2-B2>15,E2=50)
>
> for one condition, and
>
> =AND(A2-B2>15,E2=30)
>
> for a second
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "sri" <sri@discussions.microsoft.com> wrote in message
> news:354EE58D-A385-46AF-942A-B644EA483B9D@microsoft.com...
> > Hi,
> > Im trying to fill the cell color based upon the other cell conditions. Is
> > there anyway i can use the forumalas for this.
> > For Eg.
> > (if(a2-b2)> 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
> > e2=30)then f2=blue else f2=nofill)
>
>
>

You need either a macro or a UDF for that


http://www.xldynamic.com/source/xld.....Download.html


--

Regards,

Peo Sjoblom

"sri" <sri@discussions.microsoft.com> wrote in message
news:4D73118D-C1C5-405E-B0C5-71B81AE7599F@microsoft.com...
> Thanks a lot to both of you.
> I have got one more questio. I think with this, i can give maximum of
three
> condition only. If I want to give more, how best i can proceed with this.
>
> "Bob Phillips" wrote:
>
> > Use Conditional Formatting with a formula of
> >
> > =AND(A2-B2>15,E2=50)
> >
> > for one condition, and
> >
> > =AND(A2-B2>15,E2=30)
> >
> > for a second
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "sri" <sri@discussions.microsoft.com> wrote in message
> > news:354EE58D-A385-46AF-942A-B644EA483B9D@microsoft.com...
> > > Hi,
> > > Im trying to fill the cell color based upon the other cell conditions.
Is
> > > there anyway i can use the forumalas for this.
> > > For Eg.
> > > (if(a2-b2)> 15 & e2=50) then f2= red color, else if (a2-b2) ,15 and
> > > e2=30)then f2=blue else f2=nofill)
> >
> >
> >