How to check against previous cell/row and highlight row

Content

Hi,

I am using custom scripts in my report. One column I have values as below:

1. A
2. B
3. B
4. C
5. C
6. C
7. D
8. D
9. D
10. D

I would like the row to be a certain colour depending on whether there has been a shift in number. So on the above: 1,2,4 and 7 would have rows of a particular colour.

What's the best way to go about this?

I basically want to highlight the latest record for a given row

Thanks