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

V

valoriegill

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.
 
B

Bob Phillips

I think that you want

=A1<TODAY()

in your CF

--
HTH

Bob Phillips

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