Conditional formating w/ Date

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

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


"Steven Stadelhofer" <steven.stadelhofer@mci.com> wrote in message
news:2e8401c50a15$21a416c0$a501280a@phx.gbl...
>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