+ Reply to Thread
Results 1 to 3 of 3

Need help changing cell color based on percentage change

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Need help changing cell color based on percentage change

    Hi,

    I need help with figuring out how to change the cell based on percentage change between the cell I enter my value in and an existing cell value above it. It only stays green background. I have also attached the excel file, the formula should apply to 2015 row, and compared to 2014 row directly above it.

    Here is my conditional formatting:
    2015-12-22 11_05_29-Conditional Formatting Rules Manager.jpg

    Example:
    C5 has 1058, and C6 I enter 1185, this cell needs to change to green if the difference is 5% or more increase, change to brown if between 1%-4% increase.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,191

    Re: Need help changing cell color based on percentage change

    Try

    =((C6-C5)/C5 )*100>=5 Green


    =((C6-C5)/C5 )*100<5 Brown

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Need help changing cell color based on percentage change

    Thank you that worked great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Changing fill color of shapes based on changing cell value
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2012, 10:33 AM
  2. [SOLVED] Change color of cell based on percentage
    By gwymanx1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2012, 04:45 PM
  3. Change the color of a cell if its own value changes certain percentage
    By Ralphmex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2012, 05:04 PM
  4. color cell based on percentage
    By mangeshp4 in forum Excel General
    Replies: 4
    Last Post: 11-17-2010, 07:06 AM
  5. Replies: 59
    Last Post: 07-11-2010, 06:12 PM
  6. changing cell color based on changing values
    By tvonbehren in forum Excel General
    Replies: 2
    Last Post: 09-16-2009, 12:33 PM
  7. Changing font color based on change from previous value
    By dgtvr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-18-2008, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1