I have a system with a field called CLASS:
I have three classes: EDITORIAL, GRAPHICS, & FINISHING
I used Conditional Formatting to that Editorial is BLUE, Graphics is GREEN, and Finishing is FUSCHIA
Almost every layout in the system has class information on it and therefore conditionally formatted colors.
Then one client said that wanted change the colors. I could not find a way to set field color via a calculations allowing me to change all the occurrences at once.
My only solution goes way to what I did in FM5 which conditional formatting was not available.
I set colors in a preference table. I select the color in a field calculation. I place that field behind the Class field on the layouts.
Any other suggestions?