View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan
 
Posts: n/a
Default Conditional Formatting Top 10 **HELP**

Hello all -
I am wanting to highlight the Top10 cells in a range ($D$6:$D$25),
I've got the basic formula but am confused when it comes to cells with
"ties" (a.k.a. the same number), as it wants to highlight more than 10
cells.

My formula is:
=D6=LARGE($D$6:$D$25,10)

How can I modify this so it will account for a "tie" with another cell?

Thanks!
Dan