Hi i have a spread sheet or multiples where i need to format the cells bassed on percentage difference


MONTH 1 MONTH 2 MONTH 3 MONTH 4
A 100 100 200 100
b 100 100 150 175
c 100 150 170 180
d 100 100 200 220
e 100 100 180 150

See above - i need it to highlight red if the difference of previous month is more or less than 5%

Thanks Guys