Formatting Cells Automatically
There is an Excel file that teaches how to perform the Formatting Cells Automatically operation.
Excel Spreadsheet for Formatting Cells Automatically
This workbook demonstrates formatting cells automatically using VBA macros on a 261-row data layout.
Hope it is useful.