Conditional Formatting for Dates Older Than Today

[dblakester]

I would like to highlight a row based on a date in that row. Dates older than today need to highlight the row the date is in. I was able to highlight the rows based on dates within 60 days from today using this formula in conditional formatting: =AND($K1>=TODAY()-1,$K1<=TODAY()+60). I just need something like this to work for any date older than today. Thank you for your help!

 

[fhqwgads]

hope this works

=$K1<TODAY()

 

[dblakester]

Thank you very much for that formula! It does work but is there a way to keep the formula from highlighting all rows that with blanks instead of dates in column "K"? Thank you very much again!

 

[Fluff]

Try
=and(K1 < > "",K1 < Today())

 

[dblakester]

It works! Thank you all very much!

 

[Fluff]

Glad we could help & thanks for the feedback