Forum Discussion
How to highlight text cells over max length
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
- OliverScheurichGold Contributor
=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.