Need help: Macro that colors rows based on specific text

Dear all,

I am googling this one in the past day - still did not find one solution that suits my needs.

Basically I am working on automation of some charts. I have a list of 20-30 countries that should always be represented in the chart with a specific color. Every month the position of these countries will move, but also the selection (each chart will have more or less 5 countries).

Very simple, what I would like is if you find Germany in the data set below color the full row in blue. Of course we need to have each country covered and the macro not to stop after finding one market.

Germany 12 14 15 16 14 16
Brazil 12 14 15 16 14 16
Romania 12 14 15 16 14 16
Poland 12 14 15 16 14 16
France 12 14 15 16 14 16

Very happy if you can help me with this.
Thank you in advance!

Dear both,

thank you for your fast answer

still, I have tried before the conditional formatting and once I start having more than 3 markets and a longer area where to make the changes the full conditional formatting goes bananas..

Hello Kaper,

I did look at your sample from the beginning. I am trying this solution since last week but I do not understand why it does not work for me. I tried also using Search as a function but still the way colors are changing is weird and not incorrect.

For example if there is any empty row between the data, it sometimes colors that row as well, sometimes no (very randomly).
All conditions for some countries work, for some no..

Again, I am using the exact things as I am checking conditional formatting since last week..

Is there any other solution? That's why I was trying to find a macro to help me with this...

Thank you again for your help in advance!