How to highlight text cells over max length

Occasional Visitor

I'm using the current version (2021 not online) of Excel on a Mac.

 

Used to be I could set a column next to the column I am entering text into using something like LEN(G1) so that the column to the right of my working column would give me a text length measurement, and if I went over the set length, would highlight in pink.   Like if my column G went over 60 characters, the character length would show up next door in column H highlighted in a garish pink to let me know my text length was too long.

 

I can't seem to figure out how to do this in the current version of Excel...but I know I did it in past versions.  Is there an easy way to do this, or is that functionality gone?   Thanks!

1 Reply

@robert1895 

=LÄNGE(G2)>60

Maybe with this rule for conditional formatting you can highlight the cells longer than 60 characters.

=IF(LEN(G2)>60,LEN(G2),"")

This formula would return the length of a cell if it's more than 60 characters or leave it blank.