Forum Discussion
Solved
Report Builder - Expression for background colors assistance
Hi there, I am building a table report in Report Builder. The report has 3 colour ranges for Red, Amber and Green. Red is values equal to or more than 7 Green is qual to or less than 4 Amber i...
Have you tried nesting like this?
IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))
AlexisOlson
Super User
Super UserHave you tried nesting like this?
IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))
Hi Alexis. This worked perfectly. Thank you very much for helping me out!