+ Reply to Thread
Results 1 to 7 of 7

Conditional formatting on highest values in row

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,925

    Re: Conditional formatting on highest values in row

    This works for highlighting the two largest numbers.
    1. Add two helper columns populated using:
    =IF(COUNTIFS($G6:$M6,MAX($G6:$M6))>1,AGGREGATE(15,6,(COLUMN($G6:$M6)-COLUMN($F6))/($G6:$M6=LARGE($G6:$M6,COLUMNS($BG6:BG6))),COLUMNS($BG6:BG6)),AGGREGATE(15,6,(COLUMN($G6:$M6)-COLUMN($F6))/($G6:$M6=LARGE($G6:$M6,COLUMNS($BG6:BG6))),1))
    2. Apply the following conditional formatting rule to columns G:M
    =OR(COLUMNS($G6:G6)=$BG6,COLUMNS($G6:G6)=$BH6)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Conditional formatting not highlighting highest distinct values
    By StevieClem in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-25-2020, 10:48 AM
  2. Conditional Formatting (Highest value closest to that of a cell)
    By Sontal in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-23-2018, 08:55 AM
  3. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  4. conditional formatting - finding highest value
    By gocolonel77 in forum Excel General
    Replies: 2
    Last Post: 01-28-2015, 04:52 PM
  5. Conditional formatting - highest value of two columns
    By shreksbro in forum Excel General
    Replies: 1
    Last Post: 08-29-2012, 10:26 PM
  6. [SOLVED] conditional formatting - Highest
    By QPapillon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 04:10 PM
  7. Conditional formatting highest 25% of a column
    By tlosgyl3 in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 06:40 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