Hello again guys, first of all I would like to thank you in advance for the help.
Lately, I have been trying to improve the formula for highlighting a cell when time= NOW, which has been very helpful. However, since a lot of people is coming to the company, I am having difficulties with adding everyone's information because I have to do it manually. Basically, the rule I am following is "show the status a person should be (available, break, lunch, off) when time=NOW ()" in other words, IF "T3:Z64" of 'Schedules!'= Now() THEN apply the custom formula. I'm sorry if I am not being clear. Please don't hesitate to ask. See the attached file for references.
Thanks in advance,
Bookmarks