Creating a Custom Formatted Table in Excel

ImAmnesia 

To achieve custom formatting in Excel that includes different colors for specific columns and banding, you can use a combination of Conditional Formatting and Custom Table Styles.

Here is a step-by-step guide:

1. Select the range of cells that you want to format in your spreadsheet.
2. Go to the "Home" tab in the ribbon and click on "Conditional Formatting" in the "Styles" group.
3. Choose "New Rule" from the dropdown menu.
4. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
5. In the "Format values where this formula is true" field, enter the formula for formatting the first column. For example, if your first column starts in cell A2, you can use the formula: =MOD(ROW(),2)=1 This formula applies the formatting to every other row in the first column.
6. Click on the "Format" button to specify the formatting options for the first column. Choose the desired font color, fill color, and other formatting settings.
7. Click "OK" to confirm the formatting for the first column.
8. Now, to format the second column differently, repeat steps 3 to 7 with a new formula and formatting options. For example, you can use the formula: =MOD(ROW(),2)=0 This formula applies the formatting to the alternate rows in the second column.
9. Once you have applied the conditional formatting to the desired columns, you can create a custom table style to incorporate banding for the first, second, and last columns.
10. Select any cell within your formatted range and go to the "Home" tab in the ribbon.
11. Click on the "Format as Table" button in the "Styles" group and choose a table style that closely matches your desired formatting.
12. With the table still selected, go to the "Design" tab in the ribbon.
13. Click on the "More" button in the "Table Styles" group to expand the style options.
14. At the bottom of the styles list, click on "New Table Style".
15. In the "New Table Style" dialog box, you can customize various aspects of the table style, including banding options.
16. To add banding to the first, second, and last columns, click on the "Band Rows" tab. Adjust the formatting options to match the banding style you want.
17. Click "OK" to create the custom table style.

Now, when you add new data to your table, the custom formatting, including the different colors for the first and second columns and the banding, will be automatically applied to the new rows.

Note that these instructions are based on the desktop version of Excel. The options and features may vary slightly in other versions of Excel.

additional info:

Format an Excel table

Excel table styles and formatting: how to apply, change and remove