Conditional format: This Year vs Last Year

[Shenee]

Hi Guys,

I have a matrix table (see link attached) showing the values this year and values for the same period last year. What is the best way to include green, amber or red arrows next to this year's figures. So it should be green if the figure is greater than the previous year, amber if the figure is the same and red if this year's figure is less than last year's.

https://1drv.ms/u/s!AhEw68UYqcc6gxh5JbUie_w1e52L?e=y4k7tb

[Shenee · Accepted solution]

Hi All,

I managed to sort it out by intially creating a calculated field using a switch statement and then using the outcome values of the switch statement to create a conditional format using icon arrows only.conditional formatswitch statement

[v-yiruan-msft]

Hi @Shenee ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered if there is no anything else need to help about this thread? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

Best Regards