damgog

Hi,

I am trying to have a row color the same as the previous row when the data in a particular column of that row matches the data in the same column of the previous row.

Each row contains a column Set that contains an integer value. I want the row color to be the same for each row until the value of Set changes. I have been trying to do this using the OnCellColoring event without much success. My data generally contains pairs of rows but there is also the possibility that there can be 3/4/5 rows that are grouped together by Set value. I tried to reference the value of the cell in the previous row but this does not work as expected.

Any ideas?