Unable to add "AND" to Conditional Formatting statement

[Crystole Roberts]

I am trying to flag data by printing in red when the value is too low or too high, and not equal to zero. For some reason, I am able to print red if too low or too high, but am unable to have the and statement considered. I have tried adding onto the original condition statement with && data.field > 0, and have also tried adding a level to the condition. When I do the latter of these, when I go back into the .mrt, the level has been removed from the condition. Either way, zeros are still printing in red.

[Brendan]

you could use an expression for your condition.

Change the 'Field is' dropdown to expression and set your expression to something like

Code: Select all

(Data.Field != 0 && (Data.Field > 500 || Data.Field < 50))

Which would highlight any values in Red or whatever styling your condition is using for any value that are not zero and are either less than 50 or greater than 500