Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to format a table as a matrix with color striping?

13 Feb 2014   #1

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.

How to format a table as a matrix with color striping?-custom_table_format_problem.png

Attached Files
File Type: zip (8.2 KB, 2 views)
My System SpecsSystem Spec
14 Feb 2014   #2

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)

No, this is not a bug.

Please go to Design tab and make sure that check-mark "Banded Columns" is ON (checked).
My System SpecsSystem Spec
15 Feb 2014   #3


Quote   Quote: Originally Posted by Neutron16 View Post
Please go to Design tab and make sure that check-mark "Banded Columns" is ON (checked).
That's it! Thank you!

How to format a table as a matrix with color striping?-custom_table_format_solution.png

My System SpecsSystem Spec


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

Thread Tools

Similar help and support threads
Thread Forum
How do i format a Table of contents like an index
I have Word 2010 and I know how to create a "regular" table of contents (TOC), but I need a special type. I need one that shows information kind of like an index would. For example, under a title in the table of contents, it normally shows the applicable page number. Well, normally if you have...
Microsoft Office
Macro to convert table to convert table into iCalendar file?
First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on... My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so...
Microsoft Office
How to format table for text but also add columns
Word 2003 Trying to set up a two column the left main column is the right small column are $ amounts corresponding to the right text column. I can not figure out how to get the right column to line up evenly with the left...seems to be a double space in the right column...
Microsoft Office
Windows 7 RAID 0 (Striping) Performance ?
Hi all. First of all if the thread is at wrong side, mods mercy me :) I am new to RAID and yesterday i wanted to try it and i figured out i can do it from disk managment.(I think its call software RAID ?) I have 500 gb hdd with 2 partition (C: F:) (main, the hdd which is os installed) and 80...
Performance & Maintenance

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:13.
Twitter Facebook Google+