+ Reply to Thread
Results 1 to 2 of 2

Highlight highest value in each column

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Highlight highest value in each column

    Hi,

    I'm wondering if anyone can help me write a macro to highlight the highest value in a single column, but to do this for every column that has data, starting in column B or C (column A or A and B is the header for each row, so it's just text). Or would I have to just use a formula?

    Thanks.

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Highlight highest value in each column

    Lets say the range in column B is B1:B100 highlight all these cells starting with B1 so this is the active cell.
    Select Conditional Formatting>New Rule.
    Choose 'Use a formula to determine which cells to format'
    Enter =B1=MAX($B$1:$B$100) for the formula.
    Click on Format and choose your required formatting (eg. fill Red)
    Click OK and OK again.
    Say thanks, click *

+ 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. [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
  2. [SOLVED] Highlight second highest values, problem with ties
    By Djimidimi in forum Excel General
    Replies: 12
    Last Post: 06-07-2012, 10:47 AM
  3. [SOLVED] Highlight highest value
    By jjay2109 in forum Excel General
    Replies: 4
    Last Post: 05-09-2012, 07:04 PM
  4. Replies: 4
    Last Post: 12-20-2010, 05:37 PM
  5. Replies: 3
    Last Post: 08-10-2006, 11:40 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