Forum Discussion

Copper Contributor

Jun 14, 2023

conditional format cell based on current hour

I'm making a bi-hourly schedule, it consists of 4 columns E:H and 18 rows from 6 am to 11 pm. In the E column, I have the hours (10:00, 11:00,...) and in the H column, I have the half hours (10:30, 1...

excel

Formulas and Functions

myrte

Copper Contributor

Jun 14, 2023

SergeiBaklan

Hi, thank you! I tried it out a few times, but it didn't work 😕

SergeiBaklan

Diamond Contributor

Jun 15, 2023

myrte

Please check attached file if it works in your environment.

Formula in column J to test the logic

=($E3 < MOD(NOW(), 1) ) *
 ($H3 > MOD(NOW(), 1) )
 +
 ($E3 > MOD(NOW(), 1) ) *
 ($H2 < MOD(NOW(), 1) )

Conditional formatting with that formula