Forum Discussion

packie's avatar
packie
Brass Contributor
Jul 12, 2024
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   ...
excel
Formulas and Functions
packie's avatar
packie
Brass Contributor
Jul 14, 2024
I now realize what is needed is a field that will give a yes/no result.

Please see sample file...

https://1drv.ms/x/s!Ai3wejactZJ_rm3RP2yIYxZbOaUd?e=psZ8M1

Thanks
  • packie's avatar
    packie
    Brass Contributor
    Jul 14, 2024
    Perfect.
    Thank you