+ Reply to Thread
Results 1 to 3 of 3

Highlight highest value in row

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    34

    Highlight highest value in row

    Hello champions,

    In table attached please help me to highlight the highest number in each row

    Note: This is simplified. There can be columns between that do not apply.
    eg line 1. 1,2,3,4 may actually have 1 - 85 - 93 - 2 - 88 - 3 - 4 Only the columns 1, 4, 6 & 7 All rows count.
    BUT not important as I can work around this if needed to remove unwanted columns.

    Thank you, really appreciate that you take your time to help us not so smart folk.

    Kind Regards

    Bill
    Attached Files Attached Files
    Last edited by Bill Williams; 10-21-2020 at 11:18 PM. Reason: approved

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: Highlight highest value in row

    I use row 12 as helper row: mark column header with 1 if counted.

    Then using conditional formating for A13:
    Please Login or Register  to view this content.
    apply to whole range.
    Attached Files Attached Files
    Quang PT

  3. #3
    Registered User
    Join Date
    08-10-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Highlight highest value in row

    Fantastic Bebo

    Works like a charm Thank you
    Last edited by Bill Williams; 10-21-2020 at 11:05 PM.

+ 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. Highlight highest and lowest value
    By GPetcu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2019, 07:44 AM
  2. [SOLVED] Highlight the highest value of every set with one conditonal format.
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2019, 10:08 AM
  3. [SOLVED] Highlight 3 highest value in a row
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-03-2015, 05:50 PM
  4. Highlight highest value in each column
    By E2Lis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 04:47 PM
  5. [SOLVED] Highlight highest lowest value every nth row in a column
    By Cicada in forum Excel General
    Replies: 8
    Last Post: 02-04-2013, 02:22 PM
  6. [SOLVED] Highlight second highest values, problem with ties
    By Djimidimi in forum Excel General
    Replies: 12
    Last Post: 06-07-2012, 10:47 AM
  7. [SOLVED] Highlight highest value
    By jjay2109 in forum Excel General
    Replies: 4
    Last Post: 05-09-2012, 07:04 PM

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