Hello Everyone,
First of all thank you for helping each other and having passion for excel.
Today I am willing to find out solution for highlighting each cell which falls under shift time of each employee through conditional formatting.
So if employee is working 8:00 to 4:30 than each cell till 4:30 should become green.
For reference I am also attaching Excel file to see what I am talking about.
Hopping to hear back soon. Thanks in advance.
Bookmarks