Highlight More than 1 Duplicate

0:00 So you wanna highlight more than one? Duplicate , meaning we wanna find the duplicates, but only if there's three or more. So for example, we have Alice and Alice, but we have four Eves. Like it's okay if there's two cus the customer buys twice. But we wanna see who buys more than two times in this particular use case. So we're gonna highlight our B column. We are gonna go format conditional formatting and we're looking at B colon, B as the range , the whole column . We're gonna change our formula , our format , rules to custom formula is , and then we e equals count if, and we're counting in the B column for B one. Anders Asks: Can I Highlight Whole Row if Certain Columns have text? Figure Out Frequency of Numbers Highlight Duplicates of Two Columns

0:45 In parentheses, now everything is highlighted because this is always gonna come out with something. It's gonna count, it's gonna be one or something. And if it's a duplicate , it's greater than one. Meaning there's two of these. But really we wanna say more than two because if there's three, we wanna know There's three Alices here. Wow, we didn't even see that before. It's really hard to eyeball just two or three. The differences between two and three. So yeah, this works here. If you wanna highlight the whole range , we will have to change the range to like a colon C, and then we need to go to the BS and put a dollar sign in front of them. All of them. The B column B and B one, we need a dollar sign in front of that. What that does is basically holds it because when we go to the A column, Anders Asks: Can I Highlight Whole Row if Certain Columns have text? Figure Out Frequency of Numbers Highlight Duplicates of Two Columns

1:33 we're looking at the A column. When we're looking at the B column, we're in the B column if we're on the C column. So this range is looking at everything, but really for all of them, we wanna look at the B column. So it's sort of sticking to the B column no matter where we are in the range . Hopefully that was fun and interesting for you to highlight more than one duplicate , meaning there is some duplicates here, but we wanna say, Hey, is there three or more? And that's it. Count if greater than two. The. 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. 3 More Ways to Count in Google Sheets Figure Out Frequency of Numbers How to Highlight Duplicates in Google Sheets

2:19 But for right now, right here, one of these videos is gonna be your next Google sheet. Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. GPT in SHEETS Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Download Google Sheets