Uploaded November 2025 | Updated September 2026, 2 weeks ago

---

Want to instantly highlight the top 3 performers or highest values in your data — automatically? 🤩
In this quick Google Sheets tutorial, you’ll learn how to use the LARGE function with Conditional Formatting to automatically highlight your top 3 values in just seconds! ⚡

💡 Example Formula Used:
=LARGE($B$2:$B$10,3)

Then apply it with conditional formatting to spotlight the top results dynamically — no manual sorting or editing!

Perfect for:
✅ Sales or performance dashboards
✅ Leaderboards & rankings
✅ Exam or test scores
✅ Any sheet that needs quick top-value insights

📘 What You’ll Learn:

How to use the LARGE function in Google Sheets

Highlight top 3 (or top N) values automatically

Combine formulas with conditional formatting

Create smart, dynamic dashboards effortlessly

✨ Make your spreadsheet come alive with data-driven highlights!

🔔 Subscribe to @dptutorials for more Google Sheets & Excel Shorts, automation hacks, and smart formula tutorials every week!

#GoogleSheetsShorts #SpreadsheetTips #dptutorials