Forum Discussion
Solved
Paginated Report Help - Background Conditional Formatting
I am trying to create a report, that per client requests, should have cell background colour formatting for when a value is above the threshold. I am struggling to find a way around this. The values ...
It says this:
What about:
IIF(Left(Fields!humm2.Value, 1) = "<") OR IsNothing(Fields!humm2.Value) OR Fields!humm2.Value = "", "White", "Yellow")I have tweaked a little bit, I swapped the IIf into a SWITCH statement and it worked