I think that you want

=A1<TODAY()

in your CF

--
HTH

Bob Phillips

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

"valoriegill" wrote in message
...
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.