+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - Difference greater than 15%

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Conditional Formatting - Difference greater than 15%

    Hi all,

    I have a spreadsheet with 1000 rows with 256 columns.

    I would like Excel to apply conditional formatting if value in:
    Column D2 > C2 by more than 15%.
    Column E2 > D2 by 15%
    Column F2 > E2 by 15%
    So on and so forth.


    Any help will be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Conditional Formatting - Difference greater than 15%

    You could start with this Conditional Format and copy to the right

    =D2*1.15>C2
    Click on star (*) below if this helps

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional Formatting - Difference greater than 15%

    Thanks! This worked perfectly. However, is there anyway to filter by conditional highlights?

    Please ignore the attached image. I couldn't figure out how to remove it.
    Attached Images Attached Images
    Last edited by tulio; 02-04-2013 at 02:34 PM.

+ 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