I'm in the process of creating a scheduling template.
I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional formatting (highlighting specific colours based on specific text) I've already implemented. Basically, I'm trying set up the schedule so that the first row of each text is visible, but that repeating rows below only show the highlight (i.e., values suppressed)--something akin to Google Calendar. I've used data validation to create a drop-down menu (of work activities) based on the following list (kept in a separate worksheet). Keep in mind that this is my first go at this sort of thing (I'm likely going to reduce the amount of colour).