• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to color-format only MIN & MAX values in a range using CF.

I have a range of sales values for a month. Using the MAX and MIN functions i can easily find out the MAX & MIN values.
What formula must i use in Conditional Formatting to color-format the MAX and MIN values using the 2-color scale option.
Thank you, friends.
 
Hi James,

You can use a helper cell to get a Max / Min value.
Then try CF = to the helper cell. (see the attached sample file)

Although its not what you were asking.
 

Attachments

  • MAX Value (CF).xlsx
    9.2 KB · Views: 10
Many thanks Sathish and Khalid for ur solutions. Also thank u 4 the file, Khalid. That was interesting.
Here's a solution i thought i'd share.......
The simplest solution i got so far is to use the top/bottom Rules.
Top 10 items which you change to 1, and Bottom 10 items which you change to 1.
Hope u like it.
 
Back
Top