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...
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.
SergeiBaklan it seems like there was a language issue so either not translating function names or the comma vs semi-colon issue and the OP changed the excel settings and it worked
mtarler , thank you!
