+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting based on the difference value between figures in two cells

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Conditional formatting based on the difference value between figures in two cells

    Hello,
    I hope you could help me with the following issue. I would like to use conditional formatting to mark cells with arrows depending on the difference between the values in those cells and figures from different cells.
    Namely, I have percentage values in column A and B. I need cells in column B to be marked with arrows (up, right or down) when the difference between value B and A is bigger than 2%, bigger than 0 but smaller than 2%, and smaller than 0 respectively (pls see the spreadsheet attached).
    I spent some time searching for a solution to this issue but I couldn't find anything that would help me sufficiently...
    Thanks in advance for your support on this!
    Conditional Formating.xls

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Conditional formatting based on the difference value between figures in two cells

    Hello
    I don't believe you can use the icon sets relatively to other cells as you would need to do. You can create a formula in column C, however, and apply the arrows icons to that. Not sure if this does as you require but take a look at the attached file. Note I've saved this in the 2007 and later format (.xlsx) as the icons are not supported earlier and your profile states 2007.

    Hope this helps.
    DBY
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Conditional formatting based on the difference value between figures in two cells

    Hello,
    Thanks so much for your help, your solution works very well for me
    Have a nice day

+ 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. Conditional Formatting based on difference in Cells
    By QuietLife in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-26-2013, 06:25 AM
  2. Conditional Formatting help - based on difference between two cells
    By oscarbunny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2012, 10:00 AM
  3. Conditional formatting based on a percentage difference
    By Dan27 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-13-2010, 04:53 PM
  4. Conditional Formatting Based on Percent Difference
    By dontcare in forum Excel General
    Replies: 7
    Last Post: 06-25-2010, 12:17 AM
  5. Conditional Formatting Based on Percent Difference
    By dontcare in forum Excel General
    Replies: 1
    Last Post: 06-18-2010, 05:10 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