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