+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting: Format an entire row based on the contents of one column

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    74

    Conditional Formatting: Format an entire row based on the contents of one column

    Hello all,

    Looking to get a Green - White color scale applied to the entire row based on the contents of one column. I've attached an example with dummy data. Column K has the numbers by which I would format, and I'd like whatever color assigned to each of those cells applied to all the cells to the left of it in its row.

    Is this a possibility?

    Thanks
    Attached Files Attached Files

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

    Re: Conditional Formatting: Format an entire row based on the contents of one column

    You didn't actually specify what the condition was, but maybe you can work with this...

    Hightlight the entire range

    In conditional formatting enter...

    =$K1>0

    This will hightlight any row where K is greater than 0
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    74

    Re: Conditional Formatting: Format an entire row based on the contents of one column

    I'm sorry, where exactly do I enter the formula?

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

    Re: Conditional Formatting: Format an entire row based on the contents of one column

    See if this helps

    http://www.brighthub.com/computing/w...les/16957.aspx

    Home tab >> conditional formatting >> New Rule >> Use a formula to determine which cells to format >> Format values where this formula is true: Enter formula and select format

  5. #5
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    74

    Re: Conditional Formatting: Format an entire row based on the contents of one column

    Jeff,
    This worked, however I'm looking for something slightly different. When I select column K, and simply select Conditional Formatting>>Color Scales>>Green - White Color Scale, several different shades of green are applied to the cells, the shade being determined by each number's relative relationship to the others. I'm looking to see if I can apply those shades to the entire row instead of just that cell.

    Is this possible?

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

    Re: Conditional Formatting: Format an entire row based on the contents of one column

    So you want to use color scales across rows?

    I can't see a way to make this happen, but you can setup more than one condition through the conditional formatting feature.

    If you outline your requirment further maybe a solution can be developed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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