software

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)gt; 15 amp; 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-B2gt;15,E2=50)

for one condition, and

=AND(A2-B2gt;15,E2=30)

for a second

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;sriquot; gt; wrote in message
...
gt; Hi,
gt; Im trying to fill the cell color based upon the other cell conditions. Is
gt; there anyway i can use the forumalas for this.
gt; For Eg.
gt; (if(a2-b2)gt; 15 amp; e2=50) then f2= red color, else if (a2-b2) ,15 and
gt; e2=30)then f2=blue else f2=nofill)
I'm assuming that in your second condition, where you posted lt;lt;lt;quot;(a2-b2) ,15
quot;gt;gt;gt;
You really meant gt;15, same as your first condition.

Click in F2, then:

lt;Formatgt; lt;ConditionalFormatgt;,
Change quot;Cell Value Isquot; to
quot;Formula Isquot;,
and enter this formula in the box to the right:

=AND(A2-B2gt;15,E2=50)

Then, click on lt;Formatgt;
And choose Red for your Pattern, then lt;OKgt;,

Now, click on lt;Addgt;, to set your second condition.
Change quot;Cell Value Isquot; to
quot;Formula Isquot;,
and enter this formula in the box to the right:

=AND(A2-B2gt;15,E2=30)

Then, click on lt;Formatgt;
And choose Blue for your Pattern, then lt;OKgt; lt;OKgt;

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
quot;sriquot; gt; wrote in message
...
gt; Hi,
gt; Im trying to fill the cell color based upon the other cell conditions. Is
gt; there anyway i can use the forumalas for this.
gt; For Eg.
gt; (if(a2-b2)gt; 15 amp; e2=50) then f2= red color, else if (a2-b2) ,15 and
gt; 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.

quot;Bob Phillipsquot; wrote:

gt; Use Conditional Formatting with a formula of
gt;
gt; =AND(A2-B2gt;15,E2=50)
gt;
gt; for one condition, and
gt;
gt; =AND(A2-B2gt;15,E2=30)
gt;
gt; for a second
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;sriquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; Im trying to fill the cell color based upon the other cell conditions. Is
gt; gt; there anyway i can use the forumalas for this.
gt; gt; For Eg.
gt; gt; (if(a2-b2)gt; 15 amp; e2=50) then f2= red color, else if (a2-b2) ,15 and
gt; gt; e2=30)then f2=blue else f2=nofill)
gt;
gt;
gt;

You need either a macro or a UDF for thatwww.xldynamic.com/source/xld.....Download.html--

Regards,

Peo Sjoblom

quot;sriquot; gt; wrote in message
...
gt; Thanks a lot to both of you.
gt; I have got one more questio. I think with this, i can give maximum of
three
gt; condition only. If I want to give more, how best i can proceed with this.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Use Conditional Formatting with a formula of
gt; gt;
gt; gt; =AND(A2-B2gt;15,E2=50)
gt; gt;
gt; gt; for one condition, and
gt; gt;
gt; gt; =AND(A2-B2gt;15,E2=30)
gt; gt;
gt; gt; for a second
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;sriquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt; Im trying to fill the cell color based upon the other cell conditions.
Is
gt; gt; gt; there anyway i can use the forumalas for this.
gt; gt; gt; For Eg.
gt; gt; gt; (if(a2-b2)gt; 15 amp; e2=50) then f2= red color, else if (a2-b2) ,15 and
gt; gt; gt; e2=30)then f2=blue else f2=nofill)
gt; gt;
gt; gt;
gt; gt;