Forum Discussion

robert1895's avatar
robert1895
Copper Contributor
Mar 07, 2022

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 th...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 07, 2022

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.

Resources