Color changing cells by 6 dates over 200 Entries (6 possible colors)

Boston221

New member
Joined
Apr 1, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
office 16
We have a shop schedule that is already in use. We would like to add a visual in a dated chart just off to the side that will show the date and if that date in one of those cells is greater than or equal to a date in 6 different cells in the same row we would like the color of the dates with those cells to change to 1 of 6 colors. Showing us exactly what is waiting on which department on any given day. Attached is an example of what we would like it to look like visually but we would like to make these colors populate in the date area (L-NL columns) automatically based on the dates input into the (F-K columns).View attachment Example.xlsm
Screenshot 2021-04-01 093932.png
 
Back
Top