Results 1 to 10 of 10

Conditional formatting based on a percentage difference

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2008
    Location
    Manchester, England
    MS-Off Ver
    2007
    Posts
    110

    Conditional formatting based on a percentage difference

    Hello

    I wrote a question a few days ago but might not have been as clear as I could be. Apologies.

    Using conditional formatting i am trying to write a formula that changes colour on the percentage difference of another cell.

    An example would be if cell A1 contained a target of 5% in cell A2 would be an actual. If cell A2 is equal to A1 or better then it would be green. If cell A2 was within 10% less of A1 (i.e 4.5%-4.99%) then amber and red for the target minus 10% (i.e <4.49%)

    I want to do this as a conditional formatting formula as the target figure will change but 10% difference will remain the same.

    Hope someone can help

    Thanks
    Last edited by Dan27; 04-03-2009 at 10:15 AM.

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