Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to change the color of the background and font based on the value of the field. I bring in a text field into nprinting that contains the one of the words: Green, White, Yellow or Red. If the value is Green then background should be green and font white, if it is Yellow then background is yellow and font black, etc...
It doesn't look like you can do a nested if as there is only one option for the colors in the formatting rules. So I created 4 rules and attached them to the object (text field) in the report that contains the value. But it is nto working as expected. It formats them to the value of the last rule. See image. In the example below. All of the boxes are red because red is the last rule of the 4.
The formula is the same in all of them. I am just changing the text for the color and the final format.
What am I doing wrong?
my guess is that it is not finding any of them to be true so it defaults to the last one. So, is the text qualifier correct? It defaults to the brackets []. example: [Green]
Hi Deborah,
The text qualifier must use single quotation marks -> 'Green'. Try this please.
Regards.