Conditional formatting one bar of chart

[lopka]

Dear all,

I have tricky question... Could you please help me how to made Excel to colour only the column (bar) according to chosen Region in drop-down list??

I attach the example file...

It´s a bit tricky because the regions will be sorted by each parametr..

Here is the file: http://lida-malinova.ic.cz/example2.xls

Thank you very much in advance!!