Good day excel world.
I have a concern.
Below link have a list of countries that carries each country unique data.
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.
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.
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?
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...
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 decreased to -24.21 points in December from -22.47 points in November of 2024. This page provides - Albania Consumer Confidence - actual values, historical data, forecast, chart, statistics, economic calendar and news.
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 46.03 points in December from 45.02 points in November 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...
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?