Color Code Sub-Summary Report Fields

Discussion created by mikeo'neil on Dec 19, 2017
Latest reply on Dec 19, 2017 by mikeo'neil

Hi Folks,


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:

Main Category

Sub Category

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?