Highlighting Top 3 Productivity Performers Using Conditional Formatting with entire rows
We apply the following custom formula in the Conditional
Formatting rule:
=$C2>=LARGE($C$2:$C$20, 3)
How the Formula Works:
- $C2
refers to the Productivity cell in each row. The dollar sign before
the column ($C) locks the column while allowing the row number to change
as the formatting is applied down the table.
- LARGE($C$2:$C$20,
3) returns the 3rd highest productivity score in the range C2:C20.
- The
formula checks if the productivity score in the current row is greater
than or equal to the third-largest score. If it is, the condition is
met, and the format is applied.
Real-life Example:
The formula is applied to the range A2:C20, ensuring that entire
rows (EmpName, Designation, and Productivity) are highlighted when the
condition is true.
Result:
The rows for the top 3 performers are automatically highlighted with a distinct fill color, making it easy to identify high achievers at a glance. This technique is especially useful in dashboards, performance reviews, or productivity reports.
If you enjoyed learning about CONDITIONAL FORMATTING, there's so much more waiting for you! Dive deeper into the world of Excel with my eBook “Ultimate Conditional Formatting Formulas” — your complete guide to mastering powerful lookup functions like IF, AND, OR, ISBLANK, ISERROR TODAY(), NOW(), DATEDIF() OFFSET, INDEX, INDIRECT and more.
Whether you're a beginner or an advanced user, this book is packed with real-world examples, practical tips, and easy-to-follow explanations to boost your productivity and confidence in Excel.
Start your journey to becoming an Excel pro — just download your copy today !