Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Hi Need help
new to all of this' I trying to add color to a formula,if possible. here is my formula =if(c358,"J",if(c35<9,"L")) if greater than 8 I want it to turn green, less than 8 i want it to turn red. -- Tish |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Checked out Conditional Formatting:
Format Conditional Formatting Set Condition 1 for Cell value is: less than and Condition 2 Cell value is: greater than -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mtishm" wrote in message ... Hi Need help new to all of this' I trying to add color to a formula,if possible. here is my formula =if(c358,"J",if(c35<9,"L")) if greater than 8 I want it to turn green, less than 8 i want it to turn red. -- Tish |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
On the main menu, click FORMAT Conditional Formating.... Then in
Condition 1, set it to say "Cell value is...greater than...8, then click formatt button and click patterns tab, and click the green color. This is how you set it all up to say, if the cell is greater than 8, make the cell green. Now add another condition that says, if the cell is less than or equal to 8, make the cell red by the same steps as condition 1. hope this helps, dk |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
I tried conditional formatting and it will not work with the formula. I was
hoping to add something to the formula -- Tish "Sandy Mann" wrote: Checked out Conditional Formatting: Format Conditional Formatting Set Condition 1 for Cell value is: less than and Condition 2 Cell value is: greater than -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "mtishm" wrote in message ... Hi Need help new to all of this' I trying to add color to a formula,if possible. here is my formula =if(c358,"J",if(c35<9,"L")) if greater than 8 I want it to turn green, less than 8 i want it to turn red. -- Tish |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
In a round-about way, that's what conditional formatting is. (in fact,
if you click in the cell, you don't even need to see an actual formula at all!) In the conditional formatting dialoge box, that's what the conditions are. They are testing the cells you tell it to, and testing what the values are. And based on that cell's value, it will FORMAT the cell however you tell it. If this, then do that...etc. In a cell, there's no way to type "=if(.....)" and incorporate colors into the formula. What I mean is, making cells different colors is formatting it, not a formula per say. "=if(B2=4,red,green)" does not make sense. You could use VBA, but that would make it a more complicated than it needs to be. I tried your original request and it works out just fine. dk |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Thanks, I went back and found I was enter condition wrong. I am good to go
now. thanks for your help -- Tish "dksaluki" wrote: In a round-about way, that's what conditional formatting is. (in fact, if you click in the cell, you don't even need to see an actual formula at all!) In the conditional formatting dialoge box, that's what the conditions are. They are testing the cells you tell it to, and testing what the values are. And based on that cell's value, it will FORMAT the cell however you tell it. If this, then do that...etc. In a cell, there's no way to type "=if(.....)" and incorporate colors into the formula. What I mean is, making cells different colors is formatting it, not a formula per say. "=if(B2=4,red,green)" does not make sense. You could use VBA, but that would make it a more complicated than it needs to be. I tried your original request and it works out just fine. dk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|