Average value from a historical tranaction

I have a curing press that has a historical transaction to record the process values every time an operator makes a change. I am generating an excel report displaying the process tags (20 in total) on a row. To make it easier to see the changes that happen, is there a way for the reporting module or historical transaction to scan the previous row and highlight or change the fill color.