How to highlight increase/decrease using the values in next column as benchmark

[gks_19]

Hi

Please see example attached

I need to compare this week's figures with last weeks and show an increase or decrease using colours (red/green) and the increase/decrease arrow. The new figures are being compared with previous weeks figures so how do I do this ?

Thanks
Gee

[Glenn Kennedy]

From one GK to another... is this what you mean?

[gks_19]

From one GK to another... is this what you mean?

Thanks GK, is there a way to add the arrows inside column B, next to the figure?

Or any other increase/decrease symbols for that matter, can they be applied to the actual cell containing new figures ?

Thanks

[tanasedn]

Something like this?
2022-12-02.jpg

[gks_19]

Thanks guys