color

  • Thread starter Thread starter Courtney
  • Start date Start date
C

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?
 
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
 
Thanks, Dave.

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

tim
David McRitchie said:
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
Click to expand...
Click to expand...
 
Back
Top