I have a spreadsheet that counts down a date until I need to send out a
notification. If I leave the spreadsheet open overnight the date does not
update when expected (12:01am). It will update if I close and then reopen
the spreadsheet or if I wait until later on in the day.

When using conditional formatting what is used for the point at which the
date will update (it is not working off of the system time of 12:01am)?

Thank you!