Conditional Formatting based on date not working.

Question

First, please note: I am NOT an administrator, so VBAs, other programming-level fixes, etc., are not a viable option.

I am trying to use Conditional Formatting to highlight expired dates, but it continues to highlight future dates, also.

I'm using Microsoft 365 on a Windows 11 platform. I am using the 1900 date system. I am NOT importing/exporting data. I am working all within one sheet/tab of one workbook.

My columns containing dates are formatted to short date (i.e. 2024-08-18).

I want all displayed dates showing today or older to highlight yellow. I have tried using formulas and the simpler: cell value "<=today()". Regardless, it is highlighting dates in the future, as well as all expired dates. (It was also highlighting blank cells until I added the top condition in the following screen shot.)

This is a workbook created by another that I am trying to modify, but I also built a brand new sheet from scratch, manually re-entering all the data, and it responded in kind.

I don't know what else I could be missing.

Answer 1

Enter the formula =TODAY() in the box instead of today()