Hi All,
I have two tables of data that I would like to compare & contrast. The data in table1 and table2 consists of three colums: date, player ID and score.
For every date and player ID in table1, I would like to highlight the scores in green that match the score for the corresponding date and player ID in table2. Additionally, for every date and player ID in table1, I would like to highlight the scores in red that do not match the score for the corresponding date and playerID in table2. All non corresponding data can be left alone.
First I started with making a pivot table for each set of data and trying to conditional format between the two to achieve the desired result in pivot table format. However, I ran into trouble because table1 and table2 do not have the same amount of columns and rows.
I imagine this could be done without VBA, but I am not too sure and quite stuck. I am flexible and very much open to a VBA solution nonetheless.
Any recommendations on how I may proceed?
Thank you!
AjKim
I have two tables of data that I would like to compare & contrast. The data in table1 and table2 consists of three colums: date, player ID and score.
For every date and player ID in table1, I would like to highlight the scores in green that match the score for the corresponding date and player ID in table2. Additionally, for every date and player ID in table1, I would like to highlight the scores in red that do not match the score for the corresponding date and playerID in table2. All non corresponding data can be left alone.
First I started with making a pivot table for each set of data and trying to conditional format between the two to achieve the desired result in pivot table format. However, I ran into trouble because table1 and table2 do not have the same amount of columns and rows.
I imagine this could be done without VBA, but I am not too sure and quite stuck. I am flexible and very much open to a VBA solution nonetheless.
Any recommendations on how I may proceed?
Thank you!
AjKim
