cell font colors or cell shading

M

manickmj

Can you add a formula to also add a font color or shading if it is
certain number?

thank you
Mike

Ps
The cell already has a formula in it which is--->=IF(B29>599,"Straigh
in",IF(B29>501,"7:15",IF(B29>499,"8:00","8:30")))


I would like the "straight in" to be shaded and some of the times to b
colored different colors
 
F

Frank Kabel

Hi
can't be done with a formula (a formula can only return values). But
have a look at 'Format - Conditional Format'
 
S

SteveJ

If you go to Format>Conditional Formatting you can forma
any cell or range you have selected. You can use up t
three different conditions. For more help, you can searc
Excell help for Add, Change, or Remove Conditional Format

----- manickmj > wrote: ----

Can you add a formula to also add a font color or shading if it is
certain number

thank yo
Mik

Ps
The cell already has a formula in it which is--->=IF(B29>599,"Straigh
in",IF(B29>501,"7:15",IF(B29>499,"8:00","8:30"))


I would like the "straight in" to be shaded and some of the times to b
colored different colors
 
Top