Hey, so we're working on a CRM here, and we wanna add a little column that shows us the maximum. So here's deal value, and there's a few ways to get the maximum. I can actually just do this with conditional formatting . I can select this column, go and use color scale , and this color scale is just saying, hey, the maximum is going to be this dark green. I even put a number here for the minimum, so like only anything above a certain number is going to show. But I don't necessarily like this. I sort of just wanna say, where is the actual maximum? Now, can delete that color scale, and I can add a single color here, which is a custom formula, and that's just gonna be equals C1 is equal to maximum C colon C. Add Character Count and Character Limit Sales Tracker

And what this is doing is it's going to color this one. Where is it? Oh, not maximum, max. There we go. There it is. So 95,000 right there. So this formula C, equals C1 equals max C colon C will get you this custom formula , and it'll just highlight it. But that's all cool and well, but I wanna g- get something that's a little bit more, um… I don't wanna say visual at all, but I just wanna have a column here, and I'm gonna add a emoji. Just some diff- something different, something you wouldn't normally see. And I would just do here if this is equal to max C colon C, so same formula idea here, just in, uh, if. Study Better With Google Sheets 150 VCs Actively Investing by Lemon.io Highlight If Larger than Other Column

And we're gonna say, well, if it's true, do something. If it's false, do nothing, essentially. Or even put an emoji here, like a blank one, white. But if it's true, put an emoji here that's green There. It'll fill everything here, and there, boom. Next to that is 95,000. So I don't mess with the coloring or anything. I'm just adding a little showing of inf- uh, extra information, a visualization that pulls my eye a little bit. Does, it does use a whole co- column, but I think it's pretty fun. It's pretty cute. All right? And it's just using an emoji to show a maximum. But if you wanna do more stuff like this, I would totally recommend Better Numbers and Bullet Points in Your Spreadsheets 150 VCs Actively Investing by Lemon.io BEFORE YOUR SHEET GOES TO AI

going to bettersheets.co/ char , C-H-A-R, /playground. You can get there from the main website, bettersheets.co now. But this is just absolutely like, oh, it's almost 2,000 now, really cool little formulas that are going to visualize with emojis and characters what's going on in your sheets. You can do counters, timers even, pickers, uh, layouts. You can… There's stuff for writing. There's stuff for Star Wars. There's stuff for Lord of the Rings. You can actually put in a, a progress bar that's, like, taking the ring to Mordor. Some really fun stuff. Go check it out at bettersheets.co/ char /playground. You're watching Better Sheets here on YouTube. Better Sheets Members Tour March 2026 Create a ChatGPT Cheat Sheet Spreadsheet Atomic Sheets Symbols, Emojis,Arrows, Shapes, Braille & Fun in Google Sheets

You have two options here for your next video. Before you go, comment down below if you have any question whatsoever, and I'll make future videos from those questions. But for right here, right now, one of these videos could be your next Google Sheet Better Sheets Videos Checklist Roasting Google Sheets Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. The Ultimate Weight Tracker Template