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!

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

On Dec 11, 9:30*pm, WHintz67
wrote:
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!