jsayers2869
02-23-2021, 05:15 AM
Hello! I was hoping for some help.
I tried recording a macro for what I wanted but it didn't work out as needed. I am trying to compare two rows of data against one another. I have to annotate any changes I find within the two rows I am comparing. For example Row 1 vs Row 2. Row 3 vs 4 and so on.
As of now, I am manually highlighting the two rows and running a conditional format of duplicate value so only those two rows are compared against one another. Generally, I have anywhere between 500 - 2000 rows within a worksheet which tends to get time consuming. My columns range from A - AR. Is there a macro out there to run a conditional format of duplicate values for every two rows within the worksheet? I am using Excel 2016 if that helps.
I tried recording a macro for what I wanted but it didn't work out as needed. I am trying to compare two rows of data against one another. I have to annotate any changes I find within the two rows I am comparing. For example Row 1 vs Row 2. Row 3 vs 4 and so on.
As of now, I am manually highlighting the two rows and running a conditional format of duplicate value so only those two rows are compared against one another. Generally, I have anywhere between 500 - 2000 rows within a worksheet which tends to get time consuming. My columns range from A - AR. Is there a macro out there to run a conditional format of duplicate values for every two rows within the worksheet? I am using Excel 2016 if that helps.