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