Share via

Conditional Formatting Top 5

Anonymous
2023-01-19T20:08:12+00:00

I have a column where I would like to apply conditional formatting to the top 5 values. A couple of the cells have the same value, which fall 3, 4, and 5 in the ranking, wherein that ranking stops. I want the formatting to look at this as a 'Tie', for better lack of words and include the next two highest in the column. See example of what happens v's what I'd like it to look like.

Results I get :

Results I want:

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2023-01-19T20:19:41+00:00

Use CF with the formula option, using a formula like

=B2>=LARGE(UNIQUE($B$2:$B$100),5)

And choose your fill color....

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2023-01-19T20:53:25+00:00

    Perfect, THANKS.

    Was this answer helpful?

    0 comments No comments