Highlight Top and Bottom Performer
Excel Tips and Tricks

Highlight Top and Bottom Performer using conditional formatting

In this article you will learn how to use Conditional Formatting to highlight the Top/bottom performer on the base of performance score. Top performer has been highlighted in green color and Bottom performer has been highlighted in red color. A drop-down of Top Performer and Bottom performer has been given on cell C1 using Data Validation list.

In the below image, top performer has been highlighted. To highlight the top performer we have the put the below  formula in Conditional formatting:

=AND($C$1=”Top Performer”,$E4=MAX($E$4:$E$20))

Highlight Top and Bottom Performer
Highlight the Top performer

 

In the below image, bottom performer has been highlighted. To highlight the bottom performer we have the put the below  formula in Conditional formatting:

=AND($C$1=”Bottom Performer”,$E4=MIN($E$4:$E$20))

Highlight bottom Performer

Click here to download this Excel file.

 

Watch the step by step video tutorial to learn:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *