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...
Used a different formula---Conditional Formatting is great, but not always intuitive, as you're discovering. It almost always takes me a few trial and error steps to get the result I'm seeking. Did here too.
- 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.AS2021 wrote 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?
Agreed. One of the deep mysteries of Excel: why auto-insert the quotation marks that render the function inoperable??!!
