Conditional formatting based on character count

[Rhonda H.]

I need to conditionally format the cell to be highlighted if the total
character count (=len) of the cell is greater than 50. I am close. I can do
it in multiple steps. I would like to combine it in a single formula if
possible. Can anyone help?

 

[Pete_UK]

Select the cell(s) that you want this to apply to (suppose A1 is the
active cell if you have more than one highlighted), then in the
Conditional Format dialogue you need to select Formula Is rather than
Cell Value Is in the first box, and enter this formula:

=LEN(A1)>50

Then click on the Format button, choose the Patterns tab (for
background colour) then click on the colour you want to show. Click OK
twice to exit the dialogue box.

Hope this helps.

Pete