Forum Discussion
Error with conditional formatting formula
I have an issue with the formula I created below. I am trying to create a schedule for employees that will allow them to input their appointments and see what appointment is currently underway. I cre...
Select C4:I57. C4 should be the active cell in the selection.
Use this formula for the conditional formatting rule:
=AND($C$2=TODAY(),OFFSET($B4,-MOD(ROW($B4)-1,3),0)=FLOOR(MOD(NOW(),1),TIME(0,30,0)))