I am completing a spreadsheet that confirms the contents of a PROM. There are multiple copies of the same data throughout the PROM memory space (customer requirement). For the first copy of the data, I set up a worksheet that reads the contents of the PROM and compares the contents with the required data. In setting up this sheet, Excel automatically added a compare function for two adjacent cells on the same row, and automatically changed the background color to green it the two cells matched.
I then created a number of sheets by copying the original sheet to correspond to the other copies of the data. These new sheets refuse to operate the same comparison, even though everything is identical except where the test data comes from in the PROM address space.
As the operation of the first sheet was added automatically, is there any way to get the other sheets to work the same way?
There is no Visual Basic that has been added to do this. The conditional formatting feature is very painful for a large amount of data on a number of different sheets.
In the sample provided, I never requested Excel to add the comparison and resulting background color change. It was added automatically. I just need to know how to get this to work on other sheets in the same workbook.