Need to flag a date red when the date has expired

youu would compare today() - the current date from the PC when the spreadsheet is opened
with the date you want to test
as date is just a number of days from 1900
then if the date has expired its number will be less that today()

assuming the date is in A2 to A100
select that range
goto
conditional formatting
add a formula
new
then in the formula put

=A2<today()
format and use whatever format you want = fill red or change font to red

now when the date on the spreadsheet is less than today() it will flag
and do all the A column down to row 100

NOW() also includes the time and date soo no need to use that


for 2007 or 2010 excel version
Conditional Formatting

Highlight applicable range >>

A1:A100


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=A2 < TODAY()


Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

"=A2<today()
format and use whatever format you want = fill red or change font to red"

If that date is an expiry date shouldnt that be the other way round?
If A2 is less than today then surely it hasn't yet expired?

=A2 > TODAY()

its a number of days from 1 jan 1900 on windows or 1904 osx

so if the date in the cell is 1/1/2017 -then in general format thats 42736
today() (15/2/17) in general format thats 42781

so the date has passed < today()

Oh yep, makes sense now.