Complex Heat Map using conditional formatting

[Corried]

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

This page displays a table with actual values, consensus figures, forecasts, statistics and historical data charts for - Consumer Confidence. This page provides values for Consumer Confidence reported in several countries. The table has current values for Consumer Confidence, previous releases...

tradingeconomics.com

Now let's take the 1st two example:
#1 Country: Albania Data: -13.60
Below is Albania historical values snapshot:

If you notice all there historical data are measure with a (-) number.

Albania Consumer Confidence

Consumer Confidence in Albania increased to -26.25 points in March from -27.67 points in February of 2024. This page provides - Albania Consumer Confidence - actual values, historical data, forecast, chart, statistics, economic calendar and news.

tradingeconomics.com

and

#2 Country: Argentina Data: 42.40
Below is Argentina Historical values snapshot:

If you notice all there historical data are measure with a positive number.

Argentina Consumer Confidence

Consumer Confidence in Argentina increased to 36.68 points in March from 36.04 points in February of 2024. This page provides the latest reported value for - Argentina Consumer Confidence - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic...

tradingeconomics.com

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?

 

[Corried]

Also do some Googling, for god's sake. Are you going to ask every single question on this forum?

Lol. No problem. Thanks a lot. indeed you were very very helpful I really appreciate it.