Leading the way in Microsoft Office Development

Excel will format a cell automatically based on the results of the formula.

For example most formulas return a numeric value so the returned value will be right aligned.

To be extended, formats must appear in at least three of the rows or columns preceding the new row or column.