I am working on a scheduling sheet and have different dates of occurrences on the same row. I would like to have the different dates highlighted in different colors. I am currently manually doing this procedure in Excel. Most of the information I have come across requires each task be on a new line and I would really like to keep everything on the same line.
Arrive Date: 1/1/22 Start Date: 1/15/22 End Date: 1/30/22 Clean Up: 2/5/22
I would like Arrive Date through Start Date to be "green", Start Date through End Date "yellow" and End Date through Clean Up Date "blue".