I am trying to compare information contained on 2 seperate worksheets and if the information does not match I want the cell to turn red. I have read evertying I could find and tried several different "Fixes" but none of them work.
Finer details
Worksheet #1 containes a "Master Matrix"
Worksheet #2 containes the most recent report query based on the same start date range to current date.
A daily or weekly report is generated and exported to an excel file.
The information from this report is copied and pasted into my file on worksheet #2 where worksheet #1 compares itself to worksheet #2 and anything that is different the cell is highlighted red.
Both worksheets contain exactly the same amout of columns. The number of rows can and will change as new issues or concerns are generated from the report. Also the information contained within each cell of the report can change (ie, quantities, cost, BIN code, etc) so we want an easy way for these changes to be identified on worksheet #1 by changing the color which prompts us to look at that particular cell to see what was changed. No automatic updates required, just a flag to review the modified data.
I hope that I have explained this ok.
Bookmarks