Hi. I am including a report consisting of data imported from a database. I am looking for a way to look at each row and perform some formatting based on data in each row.
1st 2 columns are ORDNO and ORDSTAT. I ran a macro to merge cells in those two columns if a row had the same data as the previous row of data. That creates a grouping by ORDERNO and ORDSTAT. Within each grouping, I'd like to automatically shade each alternate group and I'd like to highlight every instance within in each group where OPSTAT is greater than the previous OPSTAT value.
I've included a report where I've manually filled the first page or two with the shading and highlighting I'm trying to automate throughout the entire report. Hope this makes sense to someone ...