SQLTeam.com | Weblogs | Forums

Change ssrs column background color

my ssrs report has the following

Name,year,Id,pay,gross,category
Delta ,89,123,67,4500,match
Beta,89,123,65,4500,match
Dept,98,435,87,674,no match
Home,98,435,99,886,no match

I would like to change the background color for "Gross"
whenever the ID's and years are the same but the gross is not

out put

Name,year,Id,pay,gross,category
Delta ,89,123,67,4500,match
Beta,89,123,65,4500,match
Dept,98,435,87,674( change background to red only for this column),no match
Home,98,435,99,886 (change background to red only for this column),no match