• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

Excel formatting question

trying to conditional format a call to change if it is a specific % less than the cell next to it

Example: if May 2011 Cons (consumption)  goes down by 20% in 2012 I want to format cell to be green

Month      Total Cons 2011      Total Cons 2012
May       475624      512648
June       895849      950300
July               812823       839335

If it's any help the format for a 20% increase is : A2/1.2>A1

thanks in advance
0
officertango
Asked:
officertango
  • 2
3 Solutions
 
byundtCommented:
If you want to color the cell if Total Cons 2012 is 80% or less of the value in Total Cons 2011, then consider a formula like:
=C2<=0.8*B2
0
 
gowflowCommented:
You say:

If it's any help the format for a 20% increase is : A2/1.2>A1

A2 and A1 are 2 months !!! you are comparing two months ? I believe your question talk about comparing 2 years hence you meant B2 and C2 right ?

Pls check the attached workbook and what it does is the following:
It colors 2012 if the value is 20% more than 2011 in GREEN
It colors 2012 if the value is 20% less than 2011 in RED

Although this is not what you asked for but presumed that you got mixed between months and colors ... that I choose logic over your requirement.

In any case anything can be changed.
Let me know
gowflow
Cond-2011vs2012.xlsx
0
 
gowflowCommented:
Did you happen to see the suggested solutions ?
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now