find a Cell with Maximum Value in Excel Column and Color it.

Find  a Cell with Maximum Value in Excel Column and Color it.

I have a pivot table that has a column with bunch of numbers I am trying to find  which cell has the largest value and color it

Thank you
MaxColumn.JPG
jskfanAsked:
Who is Participating?
 
Mike in ITConnect With a Mentor IT System AdministratorCommented:
To create conditional formatting in your Pivot table:

  1. Select the values that you want the conditional formatting to apply to
  2. On the Ribbon, in the "Styles" section select "Conditional Formatting"
  3. Select "New Rule"
  4. Format Only Cells that Contain
  5. Cell Value
  6. Greater than or equal to
  7. =MAX(the range that you want to conditionally format)

This should then color only the cell that has the max value for the selected range in your pivot table.
0
 
Martin LissOlder than dirtCommented:
Weren't you given code in another one of your questions that does that?
0
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
An image isn't much use. You should try Conditional Formatting using a formula using the Max Function.

See this for using Conditional Formatting within a Pivottable
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
jskfanAuthor Commented:
Martin Liss

This one for a single Column.
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
Copy the formatting from this workbook.
29081914.xlsx
0
 
jskfanAuthor Commented:
That 's all in the spreadsheet you attached :29081914.xlsx
under column A:

5
6
55
3
0
 
jskfanAuthor Commented:
Excellent !!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.