Highlight all cells with only 1 letter/number

[attv]

As in topic: how to highlight in conditional formatting all cells with only 1 letter/number in it?

Basically, I have a lit of names and sometimes I have only the first letter of the surname present like: L,P, D,

I want to highlight those to manually fix the names

 

[JamesCanale]

MrExcelPlayground.xlsm
	I
2	carrot
3	potato
4	bean
5	a
6	bean
7	6
8	carrot
9	c
10	bean
Sheet46

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:I10	Expression	=LEN(I2)=1	text	NO

 

[attv]

Can you apply this to 2 columns? B&C?

 

[JamesCanale]

Sure. Pick whatever range you are interested in. Use conditional formatting, then "Use a formula to determine which cells to format", then put the formula:
=len(b2)=1
assuming b2 is the first cell in the range.
then set the formatting as desired.

 

[attv]

Thank you very much! I've just entered the formula and indeed it marked all the letters.

Problem was some of the single letters like D, E - had also space after them, so I needed to change the value to =2 - but it works just fine as it also highlighted some weird names like CJ

 

[Rick Rothstein]

Try James formula this way to account for those cells with single characters and spaces...

=LEN(TRIM(B2))=1