Hey there stranger!

Sign up to get access.

Add Character Count and Character Limit

About this Tutorial

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting

Featured Formulas

Video Transcript

 Hi. I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting. So we might have a tweet here. This has 277 characters, and we know that because we literally use the formula equals l e n, and then the text.

So l e n stands for. And it's counting the number of characters. So in order to do this 39. Literally all we do is we have to figure out what maybe this, this is gonna be all tweets and this is the character count, and we're gonna put here equals l e n, and then in parentheses just takes one argument, the text.

And we can do this. So here. And so as we, as we type, it's counting, right? Every time we hit enter.

Maybe something like a tweet. If we're writing tweets here, we'll want to know that we hit some limit. Like this number might not be enough for us to stop, right? It might, we might get it a little it might become a little bit blind to it. So if we, if we go over a. , we can do it a a couple of ways.

One is we can just put on the exact defi additional formatting. So we just right click conditional formatting and we apply a single color. We're gonna apply a red And then maybe we'll change the text to Blue just to double it. And the format sells. We're gonna do it if it's greater than 280. We'll just put a number there.

And now if we go, if we go over the count, , it'll change colors, right? But what if, if we know our limit yet? Like what if this is like, if we want to, if we know our limit, and it's gonna be the same across everything right now, if I have texts here, okay, it's gonna work, right? But what if I don't know my limit and I wanna set another column limit?

That just takes an an extra little thing. We are going to set this as a limit of. Let's see. Lemme actually copy this. 20 so big, right click conditional formatting. We're gonna add another rule. And for D nine, that cell, we're going to say greater then. Now, if we wanted to put in E nine right here, it would not work.

Okay. But if we put an equal sign in front of that equals e. Now suddenly this is working. So maybe we say that like, and now we can also put a couple like, like lower limit. Like we can put a minimum minimum and then a upper limit. Upper limit or maximum. And we can say, okay, we want it between. 20 in the hundred.

Now we can do two conditional formatting, right? And say, okay, it's gonna be yellow if it's less than E nine done. And we'll add another rule and it'll be, if it's greater than E equals F nine, we'll make it red.

And so let me put in, now let's take this, and now it suddenly turns red, right? If we. . And if we have less than 20, it's yellow. So this gives you an upper limit, a minimum limit. Now you can do a lot of really cool stuff and then you can also change these on the fly, right? And be like, oh, I actually meant, you know, 50 and 300.

Oh, I actually meant, you know, 850.  And this will update. Does it update as we go? Oh, it's because we have this trash, this one. So now, It'll be perfect, right? So sometimes these, these conditional formatting go over that is one challenge with conditional formatting is that this order over here matters and it'll do the top one first, then the bottom one, and you can use that to your advantage.

Or sometimes it's you just saw it works against you and you don't know why it does something. Just look at the order of the conditional formatting. Cool. Now you have know how to do a character count and a character.