Forum Discussion
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...
I used "Format only cells that contain". Then applied the "Less than" condition to TODAY(). The quotations were inserted by excel - never would've figured to delete them after having applied the condition: if excel auto-added them, what could be wrong with it? Now I know.
Thank you all.
Thank you all.
