I think that you want

=A1<TODAY()

in your CF

--
HTH

Bob Phillips

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

"valoriegill" <valoriegill@discussions.microsoft.com> wrote in message
news:9D82FD64-4BC3-4240-92D6-BAB8B70B3DFD@microsoft.com...
> 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.