Results 1 to 8 of 8

Conditional formatting with a % tolerance

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2003
    Posts
    72

    Conditional formatting with a % tolerance

    Good afternoon all. I hope Friday is treating you well.

    I have attached a sample of a workbook. It's a standard RAG table showing a baseline for "clearance times" of incidents, with one month's results RAG'ged to that baseline. What I'm trying to work out is how I do the following:

    Green for LESS than the baseline
    Red for MORE than the baseline
    Amber for 5% EITHER SIDE of the baseline, whether that's 5% more or 5% less.

    I've tried to run various formulae in the conditional formatting window but failed miserably.

    Assistance will be met with my sincere best wishes for the bank holiday weekend and the promise of a beer if I ever meet you, however unlikely that seems.
    Attached Files Attached Files
    Last edited by Redder Lurtz; 08-28-2009 at 10:04 AM. Reason: Solved

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