formula

[mtishm]

Hi Need help
new to all of this'

I trying to add color to a formula,if possible.
here is my formula
=if(c35>8,"J",if(c35<9,"L"))
if greater than 8 I want it to turn green, less than 8 i want it to turn red.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[dksaluki]

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

 

[mtishm]

I tried conditional formatting and it will not work with the formula. I was
hoping to add something to the formula
--
Tish

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[dksaluki]

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

 

[mtishm]

Thanks, I went back and found I was enter condition wrong. I am good to go
now. thanks for your help