color

[Courtney]

Does anyone know what the formula or blurp is that you can
change the color of a cell or text when it changes. i
want the word late to be red. and the words on-time to be
bold black. does anyone know how to do that?

 

[Tim Otero]

Use conditional formatting. Go to Format|Conditional formatting, then, for
Condition 1 select "Cell Value is" "equal to" and in the last box type in
"late" (no parens). Click on format and select red for the font color. Next,
click on Add>> and repeat the same for "on-time"

tim

 

[David McRitchie]

But first select the Column(s) that you want to apply the Colors to
from the Conditional Formatting.

My page on Conditional Formatting is
--- http://www.mvps.org/dmcritchie/excel/clondfmt.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

 

[Tim Otero]

Thanks, Dave.

I usually point them to your site...just missed this time

tim

But first select the Column(s) that you want to apply the Colors to
from the Conditional Formatting.

My page on Conditional Formatting is
--- http://www.mvps.org/dmcritchie/excel/clondfmt.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

Use conditional formatting. Go to Format|Conditional formatting, then, for
Condition 1 select "Cell Value is" "equal to" and in the last box type in
"late" (no parens). Click on format and select red for the font color. Next,
click on Add>> and repeat the same for "on-time"

tim