Hello,
I have the following situation.
In column A, I have many rows with let's say these values:
A1."abc123"
A2."abc143"
A3."abc454"
A4."abc566"
etc
In column B, I have many rows with text, and some of the rows will contain the exact text in the cells from column A.
For example:
B1."rfefhefeh abc123 efref"
B2."dhfherf abc566 thhewd"
B3."cjhuherffefehg abc454 gtgrhyjyu"
B4."werfje abc999 fhvdhfe"
Now, I need to highlight all cells in column A and all cells in column B that will match in values. In this example i need highlighted A1, A4, A3 and B1, B2, B3.
Is there any way in which i can get this done for a sheet containing approximately 10000 rows?
Thank you very much!!!
Bookmarks