Forum Discussion
Solved
Check for matching records in a range using conditional formatting
Hi, colC and colD contain lists of stocks C contain both the company name and the stock ticker. Example: 1SPATIAL PLC (XLON:SPA) D only contains the company name. Example: 1SPATIAL PLC ...
- Can you elaborate some more I am not following what you mean.
- if possible,share a workbook file for testing.
Conditional formatting iterates cells in applied range one by one. We apply it to the range in column C and in conditional formatting rule formula use relative reference on the first cell in that range.
Formula takes left part of the text before " (" and try to find it in column D. If found the cell is highlighted. I assume in both columns are plain texts, not rich data types.
If you mean another logic please indicate on above or other sample what shall be highlighted and why.
File is attached.
