formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mtishm - 22 May 2008 23:13 GMT

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.

Signature

Tish

Reply to this Message

Sandy Mann - 22 May 2008 23:30 GMT

Checked out Conditional Formatting:

Format > Conditional Formatting

Set Condition 1 for Cell value is: less than
and Condition 2 Cell value is: greater than

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Hi Need help
> new to all of this'
[quoted text clipped - 4 lines]
> if greater than 8 I want it to turn green, less than 8 i want it to turn
> red.

Reply to this Message

mtishm - 23 May 2008 00:27 GMT

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

Signature

Tish

> Checked out Conditional Formatting:
>
[quoted text clipped - 11 lines]
> > if greater than 8 I want it to turn green, less than 8 i want it to turn
> > red.

Reply to this Message

dksaluki - 23 May 2008 03:19 GMT

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 to this Message

mtishm - 23 May 2008 03:59 GMT

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

Signature

Tish

> 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
[quoted text clipped - 10 lines]
>
> dk

Reply to this Message

dksaluki - 22 May 2008 23:31 GMT

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

Reply to this Message