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)