View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default Conditional Formating

Hi Debbie,

In conditional format enter:
Formula is
=<your cell < TODAY()
Format font red

Wkr,

JP


"Debbie" wrote in message
...
Hi! I would like to do a conditional format based on today's date.

My cell has a date entered in it. If the date is less than today, I
would like it to format to red font. Can anyone tell me how to do
this?
Thanks!