In a 24-hour time stream, want insert times from working card automatically colored

Nikko

Board Regular
Joined
Nov 26, 2018
Messages
72
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

Time steam.GIF

Any help is welcome.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,119,253
Messages
5,576,978
Members
412,755
Latest member
Alishk
Top