Conditional formatting based on character count

R

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?
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top