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)
|