I have attempted to create a row highlighter in the attached. I have created two table calculations to show you how I have attempted to reach the solution. You will notice that I have used the Table Calculation - LOOKUP to try and compare the consecutive values to define the highlight options.
Would this work?
Yes that does the trick!
Thanks very much for your help Siraj.
You are very welcome!