I am interested how some of you might handle this task. I am doing a project for a friend and he asked that I color code a report. The Report is a Sum-Summary type of report.
Each Grouping will have three text fields, and each field's (background) is colored differently, per Group, and there are 25 different Groups:
General Item – This is a result of 1:many-but all would have same color code.
I know I could use Conditional Formatting but each field would have 25 different formulas configured.
Does anyone have a different method that I might be able to use?