Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell borders and fill | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |