How to format a table as a matrix with color striping?

I want to format a table as a matrix with the rows striped and the columns striped also.
However, I cannot seem to make a table format that accomplishes that.

There are several canned table formats that stripe the rows, but none that stripe the columns.

Creating a custom table format that stripes rows works OK: excel > home > format as a table > new table style > , second row stripe > format (choose color) ...

However, but I cannot get the custom format to apply any column formatting. It shows in the "preview" correctly, but does NOT show up with the same preview pattern when the style is saved as a custom style. (The custom formats appear before the light, medium and dark table formats when created.)

Neither does it appear in the icon for the custom format, nor does it apply to the data in the spreadsheet.

Attached is a demo xlsx of what I am trying to do. Near the top, see the table that I manually colored without a format. Below, is a table I am trying to format using a custom style. Cannot get the style to apply column formatting.

Is this is a bug or am I doing something wrong? Running Office Pro 2010.

Neutron16 said:

Please go to Design tab and make sure that check-mark "Banded Columns" is ON (checked).

That's it! Thank you!