mikeo'neil

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?

 

 

Thanks-Mike

Outcomes