Forum Discussion
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...
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
myrte , in addition, perhaps for second half of an hour same row shall be highlighted and I used CF wrongly. But form formula point of view that will be exactly the same, only adjust references a bit.
myrte also asked this at the end of the discussion Conditional formatting? highlight a cell based on current time
It appears to be solved.
HansVogelaar , I see, thank you.
Have no idea why formula in this thread doesn't work for the author, but one in referenced thread works. The looks the same.
Anyway, doesn't matter now.
