Turning the text of the content of the cell into red in a conditional formula

[cfsosa]

Hello,
What I want to create is a conditional formula that works this way:


In cell I5 :

IF(E5>85.0000001, "The text of Content of E5 turns into RED",IF(E5>45.000001,"O.K","THE text of Content of E5 turns into RED"))


Basically, I want the number of cell E5 to be within this range : 45 - 85
If the number is less than 45, then the content of cell E5 turns into red
If the number is greater than 85, then the content of cell E5 turns into red
If the number is within range 45 - 85, then it prints "O.K" in cell I5

I'm attaching the file for a better understanding.
Thank you so much in advance,
Cesar

[teylyn]

Hi

you need to do two things:

1. create conditional formatting for cell E5 - select cell E5, then go to menu Format - Conditional formatting - where you can set conditions and their respective formats.

2. create an IF() statement similar to the one below in cell I5

=IF(AND(E5<85.0000001, E5>45.000001),"O.K","")


HTH

[teylyn]

Hi,

here is a step by step instruction how to make cell E5 turn red when it is below 45 or above 85.

1. Select cell E5
2. Click on the Format menu
3. Click "Conditional Formatting ..."
4. You'll see the Conditional Formatting dialog box.
5. Leave the first drop-down at the value "Cell value is"
6. in the second drop-down select the value "not between"
7. in the third box enter 45
8. in the fourth box enter 85
9. click the "Format" button
10. set the format for the cell here, for example font color red or click the Patterns tab to set the cell background color.
11. Click ok to close the formatting box
12. Click ok to close the conditional formatting box

Test your cell E5 by entering a value. If it is less than 45 the cell should be coloured as you specified above. If it is between 45 and 85, it should be the default format for the cell. If it is more than 85 it should turn coloured again.

Let me know if this works.

cheers

Teylyn

[cfsosa]

Yes, it works.
Thank you so much,
Cesar