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