+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting based upon absolute values

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    Gurgaon India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Conditional formatting based upon absolute values

    I am trying to format the error percentages. So if the value is closer to zero, cell background should be greener. If a value is far from 0, cell background should be more towards red side.

    I have about 60 cells which I want to format and my errors percentage genally fall between -50% to +50%. So I dont want to create fixed rules like
    Please Login or Register  to view this content.
    How do i achieve this in excel 2007.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,227

    Re: Conditional formatting based upon absolute values

    Hi grvs,

    Find the attached where I used gradient CF with 2010 Excel. I wonder if it will look correct in your 2007 version? If not you may need to create a helper column with absolute values.

    See http://chandoo.org/wp/2010/05/19/new...al-formatting/ for improvements to CF in 2010. Upgrade?
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    01-25-2010
    Location
    Gurgaon India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Conditional formatting based upon absolute values

    Thanks Marvin, In excel 2007, it fills background of my excel cells according to values. which does help in my case.

    what I need is can be obtained in few steps by following.
    1. take absolute values of the numbers in some other cells.
    2. conditional format these cells by 2 color scale
    3. and then paste these formatted cells to MS word. (it keeps the background but removes the conditional formatting).
    4. Copy these cells from word again and paste to excel.
    5. Put original error % in these new cells which already have desired background
    I was looking for a single step which could achieve this.
    Edit: may be not a single step, but if i can achieve this only by using excel, that would help also.
    Last edited by grvs; 10-11-2011 at 08:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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