Forum Discussion
How can I highlight cells that contain same text from any row in another worksheet?
For example: I have a column of company names in a NEW worksheet and relative info for each. Now, I have another column with company names in an OLDER worksheet. How can I highlight the r...
=NOT(ISNA(MATCH(1,MMULT(--(ISNUMBER(SEARCH('old worksheet'!$F$2:$F$20,'new worksheet'!C2))),ROW($1:$1)^0),0)))Maybe with this rule for conditional formatting if there isn't an exact match in the column of company names in the new worksheet.
Thank you guys, but I have tried both methods and I can't make it work apparently.
What I am trying to do is selecting the cells in the new sheet and:
conditional formatting-
highlight cells rules-
text that contains..-
Format cells that contain the text:-
and then I try to select the cells from the older sheet with the mouse, and after pasting that, it says "this type of reference cannot be used in a conditional formatting formula. change the reference to a single cell, or use the reference with a worksheet function, such as =SUM(A1:E5)"