Philly3719
New Member
- Joined
- Oct 26, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello all, new to the forum here but hoping one of you magnificent people can help me
I'm needing to track some class attendance data for the year (in weeks) and would like to know how I can format so if I input a % in week 2 that is greater than week 1 it displays the figure and a green arrow, if it is the same it display the figure and an amber arrow and if its less is displays a figure and a red arrow.
Here's what I'm working with, so essentially when I input data into overall2 rows, it automatically displays the trend based on the previous week. I would then like to do the same for Main Aim, M&E and TOTAL.
Any help would be hugely appreciated.
I'm needing to track some class attendance data for the year (in weeks) and would like to know how I can format so if I input a % in week 2 that is greater than week 1 it displays the figure and a green arrow, if it is the same it display the figure and an amber arrow and if its less is displays a figure and a red arrow.
Here's what I'm working with, so essentially when I input data into overall2 rows, it automatically displays the trend based on the previous week. I would then like to do the same for Main Aim, M&E and TOTAL.
Any help would be hugely appreciated.