Dynamic table background color?
I am generating a daily report showing a table of all ongoing tickets and who owns them. The list of all owners is not constant (new people being hired, sometimes a combination of a few people listed as owner) so it doesn’t make sense to try to create a rule for each owner in cell element conditional formatting. I’d like to color each row based off the unique values for owner/combination of owners (ie if owner in the first three rows is person A, owner in next two rows is person B, and owner in last row is A,B I’d like it to automatically color the first 3 one color, next two another color and last a different third color). I’d like this to happen without setting up a cell element conditional format rule for every single person and every single combinations of people. Is this possible?