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!
