Thread
:
Conditional Formatting based on match to external list
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn
external usenet poster
Posts: 193
Conditional Formatting based on match to external list
untested, assumes your list of countries is called "countries" and the
company countries column is E.
=match($E1,countries,0)
"Dawn Mann" <Dawn
wrote in message
...
Hi,
I have a list of companies, need to look at a separate list of countries
and, if any of the companies are in countries found in that list, I want
to
highlight the cell containing the company country value.
Basically, I need a formula that looks at the company country value, then
searches the entire list of countries to find a match.
I've got over 10,000 companies in one list and 100+ countries in the
second
list.
Dawn
Reply With Quote
Steve Dunn
View Public Profile
Find all posts by Steve Dunn