select multiple text instances to conditionally format a row

I want to highlight rows containing a specific country code. I managed to enter the formula to highlight all "BE" lines, but I can't find the right formula to add other countries in the same formula (eg I want to have NL CH BE DE SE etc...)

excelforum_150814.JPG

Here's the formula I'm using:
=$D2="be"

and anythinge else I tried does not work:
=$D2="be,sg,nl,de"
=$D2="be","sg","nl",
=$D2="be";"sg","nl";
=$D2=("be","sg","nl")
and a few more versions

I'm assuming it must be possible to have all the country codes I need in a single formula, otherwise I'd have to add it separately for all the countries I need.

Thanks for any suggestions.

Hi there,

Try:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Another one:

=ISNUMBER(MATCH($D2,{"BE","SG","NL"},0))

Just add to the items within the curly brackets if you want more codes.

Hope this helps.

Pete

This did the trick. Thanks Greg!

This version did not work for me. Thanks for suggesting it anyway!

Sweep had his $ symbol in the wrong place - should have been $D2

Pete

Hi again,

Many thanks for your feedback and also for the Reputation increase

Glad I was able to help.

Best regards,

Greg M