Finding values that don't have the right # of characters

[lmjannin]

I am working with a spreadsheet (received from an external source) where all values should have 9 characters. I want to highlight the cells where the values are fewer than 9 characters.

Is there an IF/THEN or some sort of function that I can use to highlight? It is a very large spreadsheet, so sorting from MIN to MAX won't work because of the number of cells.

Thanks

 

[Fluff]

You can do that with conditional formatting.

Select the data > Conditional formatting > New rule > Use a formula >
=LEN(A1)<9
select your format > OK

Change A1 if need to match the first cell in the range you selected.

 

[lmjannin]

Perfect! Thanks for your help.

 

[Fluff]

You're welcome & thanks for the feedback