Hi
I have two worksheets with names. I want the dublicate name cell to be high lighted. e.g cell in Sheet1 A1 & Sheet2 B1 to be highlighted.
SHEET 1
<tbody>
</tbody>
SHEET 2
<tbody>
</tbody>
I have two worksheets with names. I want the dublicate name cell to be high lighted. e.g cell in Sheet1 A1 & Sheet2 B1 to be highlighted.
SHEET 1
A1 Gill | B1 Phillip |
A2 Erik | B2 Ricky |
A3 Jack | B3 Jason |
A4 Miecky | B4 Billy |
<tbody>
</tbody>
SHEET 2
A1 John | B1 Gill |
A2 Peter | B2 Morgan |
A3 Jones | B3 Howard |
A4 Thompson | B4 Smith |
A5 Jardine | B5 Kivell |
<tbody>
</tbody>