In a data step before the proc report, I created a variable which indicated if there was a change in the data compared to the previous row then used that new variable in the logic in the compute block of the proc report and now the cell highlighting carries over to the Excel file.
... View more
