How to create a vb script in excel to highlight a certain cell with summations

Hi,

How do you make the excel spreadsheet highlight all the summation in that particular sheet when you click one of the summations?
For example:
Col A Col B
1 2
2 3
2 3
5 TOTAL 8 Total 2

when I click Col A5, it will also highlight Col B 5.

Thanks,
Angel