VBA code for reference cells data check

**JohnSavag** · 10-23-2012, 12:05 AM

Can anyone help with creating a VBA code that sums up in a the data referenced from an index list, and if the summation matches the value of another/different cell then the cell turns green otherwise red.

For example, Sheet2 cell B1= "=Sheet1!A1" and Sheet2 cell B2="=Sheet1!A5". The sum value is in cell A10 but it typed in as a number, not as a reference.
The reason why I want to reference Sheet1 cells is because I may add or subtract lines from Sheet1 but don't want my calculations to change.

In VBA I want to check whether the value of Sheet2 (B1 + B2) which reference Sheet1 cells A1 and A2 equal the value in A10.
If this is true, cell A10 turns green, else red.

Could this code span for example cells A1...E1, A5...E5, and A10...E10?

Thank you,
John

**JOHN H. DAVIS** · 10-23-2012, 02:22 PM

Does this help?

Please Login or Register  to view this content.

**JohnSavag** · 11-05-2012, 01:09 AM

Thank you this has been pretty useful!

**vlady** · 11-05-2012, 01:29 AM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.