I have data for months and years as follows:-
2017 2018 2019 2020
Jan 150 175 160 200
Feb 160 170 180 220
Mar 210 185 160 200
Apr 195 200 200 250
...
I want to apply CF to show whether the same month is > or < than the same month in the previous year e.g. so if Jan 2017 is < Jan 2018 then the cell goes red, > it goes green. I'm trying to do it so it shows a comparision between a month and the same month in the previous year to that month. Hope than makes sense
2017 2018 2019 2020
Jan 150 175 160 200
Feb 160 170 180 220
Mar 210 185 160 200
Apr 195 200 200 250
...
I want to apply CF to show whether the same month is > or < than the same month in the previous year e.g. so if Jan 2017 is < Jan 2018 then the cell goes red, > it goes green. I'm trying to do it so it shows a comparision between a month and the same month in the previous year to that month. Hope than makes sense