SSRS Change cell color depending on SUM value

Question

I am loading a dataset into my report and filling my last column with this expression: =Sum(Fields!ID.Value) and it loads fine, I am trying to put a condition in so when the number is less than 15 for example, the cell color will change to red. I have tried so many different syntax but nothing works... it must be pretty simple...? The errors I am getting are: The value expression for textbox has scope parameter that is invalid for aggregate

Any help would be good :)

Answer 1

To set the background color Click on the cell and in properties window on your right hand select the BackgroundColor property and then set expression to that property.
Or right click on cell and select TextboxProperties -> Fill and at the start there is option to set the expression for fill color. You are using the wrong expression the expression should be ,

  = IIF(Sum(Fields!ID.Value) < 15,"Red","Transparent")

You can change the Transparent to whatever color you want.Take a look here on how to use expressions.