Hello everyone,
"Small" question .
Would the times entered appear in color depending on colleagues.
Example: I have a 24-hour time stream from 6:00 a.m. to 5:30 a.m. and a Working time card where I enter the working time.
Now, if the time from 6:00 a.m. to 2:00 p.m. (8 hours) is entered in the time card, the boxes should be in the timeline from 6:00 a.m. to 2:00 p.m. with a color depending on the colleague.
Can I do this with conditional formatting or VBA?
If yes... how?
Link: Example Excel
Any help is welcome.
"Small" question .
Would the times entered appear in color depending on colleagues.
Example: I have a 24-hour time stream from 6:00 a.m. to 5:30 a.m. and a Working time card where I enter the working time.
Now, if the time from 6:00 a.m. to 2:00 p.m. (8 hours) is entered in the time card, the boxes should be in the timeline from 6:00 a.m. to 2:00 p.m. with a color depending on the colleague.
Can I do this with conditional formatting or VBA?
If yes... how?
Link: Example Excel
Any help is welcome.