using 2 font colors in one cell?

[LABYRNTH]

Can you use 2 font colors in one cell?

How?

Like we use % to show low and high production

so if the % gets under 80% i want it to show red and above 80%\
i want it to be blue and this is within one cell.....can it be done?

....can anyone help on this?


e-mail me if you like (e-mail address removed)

 

[Gord Dibben]

Check out the options available under Format>Conditional Formatting.

Condition one. Cell Value is: less than 80---red
Condition two. Cell value is: greater than 80---blue

You decide what color for exactly 80.

Probably equal to or less than/greater than.

Gord Dibben Excel MVP