Hello! I'm hoping someone could help me.
In the attached sample spreadsheet, I need vba to highlight any cell that has a partial match of the P# text to any other cell across three columns. The data may or may not be in the same row or the same column but it will always start with a capital 'P' with a four digit number.
For example:
P8448 appears in A2 and A4 and C2 so I want all three cells highlighted
P8621 appears in A3 and B2 so I want both cells highlighted
Thank you!
Bookmarks