How to shade cells based on formula of % growth/loss of last year?

W

WHintz67

I want to write a formula for 35 cells to shade them either red for 15% or
more loss base on last years sales or green for 15% or more growth. Anything
in between would be left white. How do I write this? Thanks!
 
M

muddan madhu

assumed col A last year data
col B current year data

for col B use conditional format
Condition 1 : formula : =B2>(A2+A2*15%) | choose green color |

condition 2 : formula : =B2<(A2-A2*15%) | choose red color | ok
 
Top