Hi I had a thread here

https://www.excelforum.com/excel-for...ious-cell.html

This was for the excel part and I also need it for google docs.

When I saved my Excel doc and uploaded it to google it didn't copy the conditional formatting over.

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.

Thanks.