How do I compare a row of 30 cells with a value in each to compare and high light the highest. Some will have 0 in them.

Posted on 2014-09-02
Last Modified: 2016-06-10
I need to compare multiple cells in a row.  These cells have numbers in them, and I want either a macro or something that looks at the cell values in the row and flags the cell with the highest value.
I tried the formula =B2=MAX(B2:AE2) It has came back with a true / false answer.  I need to have the highest value highlighted as previous asked by  Rugoingwme.  I can't find conditional formatting on my MS Office Ultimate 2007 either.  Is this why I can't get the result I'm after?  Would appreciate some helpful advise.
Question by:Ian Lucas
    LVL 47

    Expert Comment


    isn't Conditional formatting

    at Home /  Styles / Condtional formatting

    LVL 81

    Accepted Solution

    See the attached file. I placed random numbers in B2:AE2. The highest value is set in red font. This is done using a conditional format with the formula:


    To enter the conditional format, select the cells B2:AE2 with B2 active. Select Home:Styles:Conditional Formatting:New Rule. Select "Use a formula to determine which cells to format". Enter the formula above and select the desired format to use to highlight the cell with the highest value.

    LVL 81

    Assisted Solution

    by:zorvek (Kevin Jones)

    Author Comment

    by:Ian Lucas
    Thanks Kevin,
    It took me a little while but worked it out after you posted the step by step instructions.
    Your help is gratefully received.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
    It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
    Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
    Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now