Making a spreadsheet to plan my day: Highlight current time

Due to rounding differences that arise in Excel, try this conditional formula (applies to $B$2:...):

Formula:

Please Login or Register  to view this content.

Replace B2 and $B$2 with the top left corner of the area containing the times.

Unfortunately, the formula does not refresh automatically.

(found the solution)

Hello HandDouwe, thank you a lot for helping me!

I am sorry to say I didn't immediately understand your suggestion, and also your warning that it might not work automatically made me not look into it more deeply.

Also I didn't find solutions on the internet close enough to what I was looking for.

It then occured to me that I could ask ChatGPT and I was very impressed that it immediately came up with a solution. In fact I was wondering why you don't have a forum rule that says one is only supposed to ask questions when ChatGPT wasn't able to fix it! :-) Might also increase the quality of the board by reducing redundant / repetitive / too easy questions by newbies like myself, and give more time for the challening stuff.

=AND(TIMEVALUE(TEXT(NOW();"HH:mm:ss")) >= TIMEVALUE("10:15:00"); TIMEVALUE(TEXT(NOW();"HH:mm:ss")) <= TIMEVALUE("10:29:59"))

The formula works nicely and it updates fast and automatically. It looks great, I was "live" watching the bright red coloring jump from the 10:15 to the 10:30 cell, so cool!

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.