Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format ... to change into a series of numbers spread out over several columns, or click on the ...