I'm currently facing trouble with an if condition. More specifically my problem derives from a conditional formating (conditional colour) that I would like to apply to a textbox. Basis of my problem is that I have multiple alternate states and my textbox is set to StateA but the colour should depend on a selection made in StateB. Simply changing the entire alternate state of the object doesn't work since my expressions need to use StateA.
For some reasons this doesn't work and I wonder whether ther is another way to specify the alternate state StateB for my if condition without changing it for the whole object? Note that the SUM()-function is irrelevant for my calculations I just used it to set StateB.
All I want to do is have the object change the colour if MyField in StateB is not selected.
I'm now facing a follow-up problem and it'd be great if someone could help me with this:
While I wanted to use conditional colouring if no selection is made, I would now like to colour conditionally if a specific value is selected. Again I'm facing the problem of different alternate states: My object is StateA and my Selection will be made in StateB.
So basically what I want to do is colour my StateA textbox in a different colour based on what selection is made in my StateB listbox.