Forum Discussion

bmccutch98's avatar
bmccutch98
Copper Contributor
Aug 17, 2017
Solved

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...
  • SergeiBaklan's avatar
    Aug 17, 2017

    Hi,

     

    You may use conditional formatting with the rule like

    =LEN(A1)<>10

    applying it to all your cells

     

Resources