Conditional formating w/ Date

[Steven Stadelhofer]

I would like to format a date cell based on todays date.
e.g., if date before today format red font, if date after
today format black font. I can't seem to get this
condition to work for all my cells? not sure why.
Thanks for your help.

Steve

 

[JulieD]

Hi Steven

for the dates prior to today:

select the cells
choose format / conditional formatting
choose
cell value is
choose
less than
type
=today()
click the format button - set font as red
OK

for the after today :

click the ADD button
choose
cell value is
choose
greater than
type
=today()
click the format button - set font as black
OK twice

Cheers
JulieD