Hello, I am trying to get the calendar view of my sheet to reflect different colors for each audience in training classes. 2 rules are working but my last one is not.
The goal is to have classes that are all 3 audiences be light blue (default)
Green classes are DBM audience
dark blue classes are NSS audience
Purple should be Assoc NSS classes, but no matter what order I put it in, there is no purple populating on my calendar. There are at least 10 classes that only have the Assoc NSS audience listed.
Any ideas why this is not working? Thanks!