how do you conditional format based upon today's date?

I need to highlight when data is input on a date previous to today's current
date. To track whether employees are inputting their information when the
work is performed or at a later date. I cannot determine the formula
necessary within excel to complete this task. Any help would be greatly
appreciated.

I think that you want

=A1<TODAY()

in your CF

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"valoriegill" <[email protected]> wrote in message
news:[email protected]...
> I need to highlight when data is input on a date previous to today's
current
> date. To track whether employees are inputting their information when the
> work is performed or at a later date. I cannot determine the formula
> necessary within excel to complete this task. Any help would be greatly
> appreciated.