I have about 50 columns where each column contains either the term "act", "budg" or "YTD".
For example: Sales_act, Sales_budg, Sales_YTD
I would like to assign color codes to each of these three "categories", so that I can give every column containing the word "act" a blue color and "budg" a red one within the background color expression of chart objects. If it would work to actually put them in a category column I could try that as well.
I know how to set the color codes when I have records within one field but for individual columns I haven't figured out a solution yet.