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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to disallow shading in certain columns 2
conditionally formatting 3
named ranges 4
adding color to cells based on a formula 2
Counting occurances based on multiple variables 4
Formula to auto calculate based on other variables 8
Summing on year and text conditions 6
Formula for Dates and CF Colour then convert to Text 3

Top