Forum Discussion

nurkoandrea's avatar
nurkoandrea
Copper Contributor
Sep 13, 2022
Solved

Conditional Formatting Not Registering Today's Date

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 tr...
  • HansVogelaar's avatar
    Sep 13, 2022

    nurkoandrea 

    This is because the cells contain the time as well as the date.

    Use Cell Value, less than, and =TODAY()+1

Resources