Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • Last Modified:

Auto Operation of MS Excel 2013

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.

Thanks,

Mark
Auto-Background-color-sample.pdf
0
TMarkB
Asked:
TMarkB
1 Solution
 
Adiel de FreitasHelp Desk/Network TechnicianCommented:
I found a great article that describes how to apply Conditional Formatting to an Excel Worksheet.

https://www.ablebits.com/office-addins-blog/2015/08/26/excel-compare-two-columns-matches-differences/

I believe setting up the formula will work both numerically and with lettering.
0
 
TMarkBAuthor Commented:
Thanks for the help!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now