In a previous video, I showed you how to highlight the highest score on a leaderboard. So if this changes, like we have this, see, it's highlighting it. So let's look at this highlight, and I'm gonna show you how to do the second highest score up to format conditional formatting . And this is our custom formula . We've said B one. Item in the B column is equal to the max of the B column. Well, to get second, we can't just add two here. That's actually a different formula called large. And now when we do large and we use the B column and we put the two there, we're looking at the second largest number . And if there's. The same number here. It'll highlight two of them because it's looking at literally the same exact number and it's saying these are the second highest numbers. Just a little note there for you about duplicates.

It's going to highlight both, and we can do third as well if we just put a three here. Instead of a two, as the second unit of this large formula . Hopefully. Hopefully you enjoyed that. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.