all right so in this video let's talk about character count and how to do conditional
formatting that will tell you that you went over a limit or you're under the limit something like
this so first of all let's just create a column for us here and below we have our phrase or word
it doesn't really matter so now if i wanted to know how many characters long this is i
would just go right next to it and do equals len and click on that text and that should tell me
how many characters long that is so seven so it doesn't matter if it's a single word or a phrase
it still works see 10 characters one two three it's also going to count spaces so now using this
we should be able to apply conditional formatting so what we can do we can do a logical test
so let's say we want to allow maximum 15 characters long text so what we can do we can just
check is that greater or equal to 15 and right now see it's gonna give us false but if we keep typing
see at some point it's true because it goes over that limit so let's just check how long this is
see that's 22 characters now so now let's say we want this to turn red when this happens so all we
have to do is just copy this formula hit escape and you could just do it with this single cell
or maybe you have a whole column that you want to check for this so you can just highlight starting
from here and however far you need this to go and go under format and conditional formatting
and here under this tool we're gonna find this option
custom formula and we're gonna paste our formula right here and now we're gonna just
apply some sort of formatting so let's say we want this to go red background and white text
so now at this point if i just go back and
do less characters 15 or more characters that's what i did so apparently we need to do 14
to be in the limit if you wanted that to be 15 then you could just go in here and change this
formula to just do greater than 15 and hit done and now if i go back and add another character
see it still fits within 15 but if i add more well let's just do one more character see now it's red
now this is gonna work for this whole column so apparently that's still within the limit
and at some point when it goes over the limit c it goes red now you could also apply conditional
formatting when it's within the limit so let's say when it's within that limit you want this to be
green so for that you would just change this formula and say if it's less than or equal 15
then you want to basically color code this so at this point i'm gonna copy that formula
hit escape go back and select this range and add another rule
custom formula is and paste the formula in here
and finally choose whatever color you want this to be
so now it's going to be this green color unless you go over the limit and then it's
going to go red and you don't need to keep these formulas it's still going to work the same way
so that's our conditional formatting based on length of characters in this column and that
should take care of this thanks for watching please subscribe and i'll see in the next one