Fill background based on other Filled Backgrounds

Hi aivoryuk,

If I understand correctly, you want to use some columns color to control the other column color in the report. We can use the other columns conditions to control the specific column’s color.

Suppose we have two columns’ color is control by Name and Amount fields values. In the third column, we can use following expression to control the color:

=IIF(Fields!Name.Value=”A” or Fields!Amount.Value=255, “Red”, “White”)

If there are any misunderstanding, please elaborate the issue for further investigation.

Regards,

Alisa Tang

---

Alisa Tang

TechNet Community Support