How to Highlight 3rd Highest Number in Column

Google Sheets Conditional Formatting: Highlight the Third Highest Score (and Top 3) with LARGE()

This video shows how to use Google Sheets conditional formatting with a custom formula to highlight the third-highest score on a leaderboard. It walks through removing an existing rule and recreating it by applying a rule to a score range (e.g., B2:B) using LARGE(range, 3) to target the third-highest value. It also explains how to extend the highlighting from a single cell to an entire row or wider range (e.g., A:C) by using absolute references (adding dollar signs) so the formula always checks the B column. Finally, it demonstrates how to adjust the range and formula to highlight the top three scores using a “greater than or equal to LARGE(..., 3)” approach.

00:00 Third Highest Setup
00:22 Create New Rule
00:37 LARGE Formula
01:14 Highlight Full Row
02:00 Top Three Scores
02:37 Wrap Up
02:38 End Screen

Видео How to Highlight 3rd Highest Number in Column канала Better Sheets