Forum Discussion
AS2021
Sep 15, 2021Copper Contributor
Conditional formatting not reading dates
Good morning, I have a spreadsheet in which dates have been formatted as dates in the Home tab, and where I already tried using "Text to Columns" in the Data tab to make sure the dates are format...
HansVogelaar
Sep 15, 2021MVP
Th rule says Cell Value less than ="TODAY()"
But "TODAY()" is a text string, not a date. Change ="TODAY()" to =TODAY()