Quickly Highlight Long Text
Learn how to quickly highlight long text in Google Sheets using conditional formatting based on character length. This tutorial guides you through the steps to set up custom formulas for effective text management.
the ones that are over 30 characters are highlighted. This is how we do it. Select our A column where all of our text is, go up to format , conditional formatting . We have format cells if , and we're gonna switch that to custom formula is Equals LENA one. Greater than, and whatever you want to set your character length to be. 15, it highlights a bunch of them. Let's say 30. now we can see over here that