I have dates grouped by a parent and there is a "kickoff" that I need to be in green, "in progress" in yellow, and then "the end" to be in red. I have the conditional formats and everything set up, but what is stumping me is I can't get the bars that are the same location to stay lined together when in the Calendar View.
I thought I figured it out, by organizing the rows in the grid view, but that only worked for a short time until many more dates were mixed in to the list. I also tried sorting by type and then by number (bar title) and still didn't work for all weeks.
I need the different color rows to line up to match the numbers in the example