Challenge creating heat map-data carries there own unique values

Hello Excel World.

I'm in the process of creating a 3-Color Scale "Heat map", using conditional formatting for investment purposes.

But I am having some challenges in creating the heat map, because each data carries there own unique values and may differ extremely from each other.

See Link below, of countries listings and the values outline under the header "LAST"

https://tradingeconomics.com/country-list/consumer-confidence

I also thought with myself. If the heat map should work effectively, each value or each cell reference should have there own heat map values.

But what is the effective way in creating these values or heat map ratio.

See link below of one of the example given.

https://tradingeconomics.com/albania/consumer-confidence

In conclusion.

What is the best direction to create this?

What are your experiences if any?

How do you want me to proceed?

Thanks in advance

Let me start over.

Good day excel world.

I have a concern.Below link have a list of countries that carries each country unique data.

Consumer Confidence - Countries - List

Now let's take the 1st two example:

#1 Country: Albania Data: -13.60
Below is Albania historical values 
snapshot:https://imgur.com/C3GjVvBIf 
you notice all there historical data are measure with a (-) number.
https://tradingeconomics.com/albania/consumer-confidence
Albania Consumer Confidence

and

#2 Country: Argentina Data: 42.40
Below is Argentina Historical values 
snapshot:https://imgur.com/ECIbh1j
If you notice all there historical data are measure with a positive number.
https://tradingeconomics.com/argentina/consumer-confidence
Argentina Consumer Confidence

My problem is this:

How can I use 3-Color Scale "Heat map", using conditional formatting, to show it correct color code for each country?

Below is the WRONG EXAMPLE of conditional formatting use

directly.

What do you suggest I do?