+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting excell 2010

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Conditional Formatting excell 2010

    Hi i have a spread sheet or multiples where i need to format the cells bassed on percentage difference


    MONTH 1 MONTH 2 MONTH 3 MONTH 4
    A 100 100 200 100
    b 100 100 150 175
    c 100 150 170 180
    d 100 100 200 220
    e 100 100 180 150

    See above - i need it to highlight red if the difference of previous month is more or less than 5%

    Thanks Guys

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,579

    Re: Conditional Formatting excell 2010

    Select all but your first column of data (i.e B2:E6 in this example).
    Conditional Formatting> New Rule> Use Formula
    =ABS(B2-C2)/B2>=5% format as red

    If you're going to extend this conditional formatting beyond your data (i.e you have empty columns), use
    =AND(ISNUMBER(C2),ABS(B2-C2)/B2>=5%)
    Does that work for you?
    See attachment
    Attached Files Attached Files
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Conditional Formatting excell 2010

    You sir a a true super star - works a treat thank

+ 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