- Trying to put together an employee scheduling workbook containing multi worksheets
- Issue : how can I color a range of cells in 1 worksheet based on (time in /time out) from another
example
Sheet 1 : cell A= employee names B=time in(5am) C =Time out(4pm)
sheet 2 : cell A1 = employee name.Would like formula to show Yellow color from 5am to 930am(cells b1:h1), green from 930am to 4pm(cells I1:v1)