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)