Forum Discussion
bmccutch98
Aug 17, 2017Copper Contributor
Excel 2010 setting rule for digit count
Hi there, I am trying to set a rule in Excel 2010, to highlight the cell if there are more or less than 10 digits entered. Our users have ID numbers that are 10 digits long, and people have bee...
- Aug 17, 2017
Hi,
You may use conditional formatting with the rule like
=LEN(A1)<>10
applying it to all your cells
SergeiBaklan
Aug 17, 2017Diamond Contributor
Hi,
You may use conditional formatting with the rule like
=LEN(A1)<>10
applying it to all your cells