How to shade cells based on formula of % growth/loss of lastyear?
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!
|