Excel for the web supports custom formats and data validation. How to determine requirements in Excel Phone numbers have 10 numeric digits and generally use the (xxx) xxx-xxxx format.

With C1 selected, click the Home tab; C1 is the same cell where we put the data validation control. In the Styles group, click Conditional Formatting. Choose New Rule from the submenu.