Sep 13 2022 07:00 AM - edited Sep 13 2022 07:01 AM
Hi,
I am trying to create a syllabus for my college semester by using conditional formatting, but the spreadsheet is not registering today's date. For reference, today is September 13th and I am trying to get the cells to be highlighted in red when today is the due date, or when today is after the due date has passed. If I write September 10,11,12, etc. in the cell, it does highlight in red; however, when I write September 13th, it doesn't.
The formula I am using is Cell Value, less than or equal to, =TODAY()
If anyone has the answer on how to fix this, I would really appreciate it.
Sep 13 2022 07:03 AM
SolutionThis is because the cells contain the time as well as the date.
Use Cell Value, less than, and =TODAY()+1
Sep 13 2022 07:04 AM
Sep 13 2022 07:03 AM
SolutionThis is because the cells contain the time as well as the date.
Use Cell Value, less than, and =TODAY()+1