Conditional Formatting States

[mkyb14]

Happy Friday!

Looking to see if there's a way to do a conditional format of a column of states that have mixed in non-US locations

Currently I have a list of employees and the states they cover
John Smith, MD, WY, TN
Arron Smith, OK, TX, FL

Each of these is a separate column.

I then have a master account sheet which has the following
Company name , state

Company foo, TX
Company A, OK
Company B, FL
Company C, AB

What I'm trying to solve for is the list of employee's is in columns with the states they support in separate cells. From the master sheet you'll see Company C is AB (alberta canada), and I'd like to figure out a way to highlight this to draw attention when reviewing the master sheet.

I tried following some rules that are similar to =match(b2,'employeestate'!a1:e10,0) on the master sheet holding the company names, but nothing seems to work from what I can google.

 

[Oscar Cronquist]

Try this conditional formatting formula:

=OR(B2='employeestate'!$a$1:$e$10)

 

[mkyb14]

Try this conditional formatting formula:

=OR(B2='employeestate'!$a$1:$e$10)

I should mention I'm working on this in google sheets. And it doesn't work either. B2 is the result of a vlookup, would that have an issue applying a conditional format to it? There are no other rules applied to this column from a conditional standpoint.