View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ferrero[_2_] Ed Ferrero[_2_] is offline
external usenet poster
 
Posts: 99
Default change font color

Hi TGS,

Format - Conditional Formatting

Set condition 1 to;
Cell Value Is
less than
=NOW() (enter this formula in the box)

Click the format button and format the font to red.

Ed Ferrero
www.edferrero.com

"TGS" wrote in message
...
I have a column of dates, and want to change font to red, for the cells
that
are < today's date. How can I do this?
--
TGS