Forum Discussion
Solved
Can't get "less than" formula to work
I am trying to highlight cells that contain dates less than TODAY(). I've used the "Cells that contain..."less then" functionality and just a straight formula functionality and can't get them to hig...
AS2021 Your "dates" are in fact texts. Have transformed them to real dates (using Text-to-columns) and your CF rules work as expected. See attached.
AS2021 Your "dates" are in fact texts. Have transformed them to real dates (using Text-to-columns) and your CF rules work as expected. See attached.
- Very helpful - thank you!
