I have a report that is broken up by state codes. I need to color code specific states, each in a different background color based on a set of criteria.
I have a formula that evaluates out to the name of the color but cannot figure out how to use the conditional formating option to do multiple colors in this case.
I am trying to color any line in the report that relates to 'CA', red; 'GA', orange; 'MN', green; 'TX', yellow, etc. There will be only 10 different colors. I have tried the Boolean, no luck. I have tried the String, not really sure how to use this one which might be why I cannot get this to work.
Can anyone help me out here?
I have a formula that evaluates out to the name of the color but cannot figure out how to use the conditional formating option to do multiple colors in this case.
I am trying to color any line in the report that relates to 'CA', red; 'GA', orange; 'MN', green; 'TX', yellow, etc. There will be only 10 different colors. I have tried the Boolean, no luck. I have tried the String, not really sure how to use this one which might be why I cannot get this to work.
Can anyone help me out here?