conditional date highlight

[wmtsub]

Using the conditional format function how can I highlight any date equal or older than today()?

 

[Special-K99]

This should work

Select the range to highlight

Conditional Formatting
New Rule
Use a formula to determine...

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

Format as required

 

[wmtsub]

I followed the instructions given, it did not work.
The sheet I am working on is formatted as a Table - does that make a difference?

 

[Fluff]

What column or range do you want this to work on?

 

[Special-K99]

Shouldnt matter, I just created a table and put a CF on it and it highlighted.

You need to change A1 to whatever the top left cell is that you want to highlight.
So if your data is in B13:J46 you need to change the A1 cell to B13.

Maybe they are not dates, this is a common fallacy.
Choose a cell you think is a date, let's say A1
In a blank cell type
ISNUMBER(A1)

If it says FALSE then your dates are not dates, they are text and the CF prob won't work in which case you'll need to change them all to proper dates.

 

[wmtsub]

Thanks everyone, this was the issue:
"

You need to change A1 to whatever the top left cell is that you want to highlight."

Changed to proper row and all is good​