JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
I am aware of the Conditional Formatting option that will highlight the top N values in a range.
Is there an easy way to highlight each of the top 3 in a different color? Can I set the background fill to gold, silver, and bronze for 1st, 2nd, and 3rd?
I tried creating three rules, one for the top three, one for the top 2, and one for the top 1. It sorta worked, but the colors kinda merged.
Is there an easy way to highlight each of the top 3 in a different color? Can I set the background fill to gold, silver, and bronze for 1st, 2nd, and 3rd?
I tried creating three rules, one for the top three, one for the top 2, and one for the top 1. It sorta worked, but the colors kinda merged.