How to use formulas in Excel to control the text color ?

[Guest]

For example, I want to use a formula to show a green "Pass" when the
value>=60 else a red "Fail". So I use "IF(C3<60,"Fail","Pass")" to show the
text, but I can not control the color, can anyone tell me, how to change text
color in the formula ? Thanks in advance.

 

[Ken Russell]

Have a look at Conditional Formatting. It will do exactly what you are
looking for.

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..

 

[JulieD]

Hi jackie

you need to use conditional formatting to do this

select the cell you want formatted and choose format / conditional
formatting
choose
cell value is
choose
less than
type
60
click on the format button - in the centre of the screen you'll see a colour
drop down .. .choose red
click OK
click ADD
follow the same steps as above but set it to test for greater than or equal
to 60 and set the colour to green. Click OK twice and test.

Hope this helps
Cheers
JulieD