+ Reply to Thread
Results 1 to 2 of 2

Conditional Format an Entire Column based on percentage of another Column

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Format an Entire Column based on percentage of another Column

    I want the cells in the entire column to change color based on the column next to it.
    For example if the cells in column N are less than Column O then I want N to change to red, if it is equal or greater by up to 10% I want them to be light green, if it is greater than 10% I want it to be light green.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Conditional Format an Entire Column based on percentage of another Column

    Maybe this...

    Conditional Formatting
    • Highlight applicable range >> N2:N100
    • Home Tab >> Styles >> Conditional Formatting
    • New Rule >> Use a formula to determine which cells to format
    • Edit the Rule Description: Format values where this formula is true: =O2+(O2*0.1)
    • Format… [Number, Font, Border, Fill] >> Green
    • OK >> OK

    Now add two more new rules:

    =N2>O2+(O2*0.1) >> Light Green
    =$N2<$O2 >> Red

    In that order
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 11-08-2013, 12:37 PM
  2. Replies: 1
    Last Post: 03-02-2013, 05:06 AM
  3. [SOLVED] Excel 2007 : Format entire columns based on date at head of column
    By CakeBloke in forum Excel General
    Replies: 2
    Last Post: 06-07-2012, 07:44 AM
  4. Replies: 5
    Last Post: 05-03-2012, 06:06 PM
  5. Replies: 3
    Last Post: 02-21-2011, 11:29 AM

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