+ Reply to Thread
Results 1 to 2 of 2

Highlight max value in block of cells from pivot table

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    28

    Highlight max value in block of cells from pivot table

    Hello,

    How do you go about highlighting the max value from a block of cells. I want to highlight the max value in a block of cells where the partial pivot table lies, - L7:N11.

    Attached is the pivot table where the max value from the range of cells is 2.3098. This value is found in Cell M10. How to highlight just that cell?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Highlight max value in block of cells from pivot table

    Apply conditional formatting show top 1 value.

    https://www.contextures.com/excelpiv...nalformat.html
    Cheers
    Andy
    www.andypope.info

+ 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. Block user before adding new pivot table field
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2020, 11:55 AM
  2. [SOLVED] Interaction through slicers only, block modification pivot table fields
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2016, 08:46 AM
  3. Pivot Table Display Block Rows not Inline Columns
    By AustinLe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-16-2015, 01:59 PM
  4. Replies: 0
    Last Post: 11-18-2014, 07:44 PM
  5. Highlight rows in pivot table when change in dataset cells value
    By kuhin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 10:49 AM
  6. pivot table - to block some info
    By mingali in forum Excel General
    Replies: 0
    Last Post: 06-18-2010, 12:35 PM
  7. End if with block if - Pivot Table Problem
    By Nav in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2006, 10:10 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