I've attached a sample spread sheet.
What i'm trying to do is the following
1) Base the formatting on the previous cell / days number - I've dates across the top
2) If the results/numbers are the same / no change, background colour will be yellow
3) if todays results is lower then previous day it will be green
4) if it's higher by 1-9 it will be ornage
5) if it's 10+ it will be red.
If i knew how to target the previous cell I think i could figure this out. The previous cell will change everyday.
Any help would be great
thanks.
Bookmarks