AnsweredAssumed Answered

User Defined Fill Color

Question asked by user28271 on Jan 14, 2018
Latest reply on Jan 14, 2018 by philmodjunk

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?

Outcomes