Conditional Formatting (or a formula) For Dates Comparing to the Current Date

[shoebox54th]

I have a group of dates that I need highlighted if they occur before todays date. (I.e. for today 8/1/13 would be highlighted, but not 8/9/13).
An alternative solution would be a column next to the date column that says if the the date is "Up to date" - Yes if date is after current date, and No if date is before current date.

Thank you.

[NBVC]

Select the column and go to Home|Conditional Formatting|New Rule, then select "Use a formula to determine which cells to format"

then enter formula:

=AND(A1>0,A1<TODAY())

where it is assumed you selected column A, starting at A1.

then click Format and choose from Fill tab.

You can use similar formula in B1, if desired instead.


=IF(AND(A1>0,A1<TODAY()),"No","Yes")