+ Reply to Thread
Results 1 to 2 of 2

Conditional Format Row and Column based on MAX value within Range

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Modesto, CA
    MS-Off Ver
    Excel 2007
    Posts
    45

    Conditional Format Row and Column based on MAX value within Range

    Looking for a method to conditionally format the entire row and the entire column associated with the Max value within a range.

    Found a few examples that focus on one column of data, but not a range. See example in attached workbook.

    Cheers in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,251

    Re: Conditional Format Row and Column based on MAX value within Range

    I did it with three CF rules.
    =B3=MAX($C$4:$H$9)
    =COUNTIF(B$3:B$9,MAX($C$4:$H$9)) - to highlight column
    =COUNTIF($B3:$H3,MAX($C$4:$H$9)) - to highlight row

    First, select all range B3:H9
    In Conditional formatting, select New Rule
    Then select Use a formula to determine which cells...
    Then paste the first formula in box under "Format values in which this formula is true"
    Select desired format
    OK

    Repeat steps to enter the other 2 rules.

    File attached.

    Good luck!
    Attached Files Attached Files

+ 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 format based on another cell column carried down column?
    By ROsmond in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2020, 01:47 PM
  2. Conditional Format an Entire Column based on percentage of another Column
    By Nolson24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 09:23 AM
  3. [SOLVED] Conditional Format Based on a Defined Range
    By Phoenix5794 in forum Excel General
    Replies: 9
    Last Post: 08-13-2012, 11:31 AM
  4. [SOLVED] Conditional Format column based on value of a range of cells.
    By pauld.ccvw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2012, 09:35 AM
  5. Excel 2007 : conditional format based on date range
    By Rob U Blind in forum Excel General
    Replies: 1
    Last Post: 10-21-2011, 09:41 AM
  6. trying to conditional format based on words in a range.
    By bopsgtir in forum Excel General
    Replies: 12
    Last Post: 11-09-2010, 07:14 PM
  7. Conditional Format based on range
    By Dave in forum Excel General
    Replies: 3
    Last Post: 06-05-2006, 01:20 AM

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