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)

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

Use Conditional Formatting with a formula of

=AND(A2-B215,E2=50)

for one condition, and

=AND(A2-B215,E2=30)

for a second

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sri" wrote in message
...
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 want to fill the cell color based upon the other cell condition
 

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-B215,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-B215,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" wrote in message
...
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 want to fill the cell color based upon the other cell condit
 

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-B215,E2=50)

for one condition, and

=AND(A2-B215,E2=30)

for a second

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sri" wrote in message
...
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 want to fill the cell color based upon the other cell condit
 

You need either a macro or a UDF for that


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


--

Regards,

Peo Sjoblom

"sri" wrote in message
...
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-B215,E2=50)

for one condition, and

=AND(A2-B215,E2=30)

for a second

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sri" wrote in message
...
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)