Finally, click “OK” in “Conditional Formatting Rules Manager” dialog box.
Then enter “=MOD(ROW(),2)=0” in “Format values where this formula is true” text box to format even rows.
Now go back to “Conditional Formatting Rules Manager” dialog box, and repeat step 8, 9, 10.
Next, click “OK” in both “Format Cells” and “New Formatting Rule” dialog boxes.
Then click “Fill”, and choose a background color.
Click “Border” first to choose necessary borders.
The “Format Cells” dialog box will pop up.
Then enter “=MOD(ROW(),2)=1” in “Format values where this formula is true” text box.
In dialog box of “New Formatting Rule”, choose “Use a formula to determine which cells to format” for rule type.
Now in “Conditional Formatting Rules Manager” dialog box, choose “This Worksheet” for “Show formatting rules for”.
Now select the entire sheet and make sure that “Home” tab is displayed.
And on the drop-down menu, choose “Excel Spreadsheet”.
To begin with, open Word, and place cursor where the table goes.
And then take the exact same steps to accomplish your mission.Īfter colors are set to columns, you may find all table borders missing. And when you insert a row into the table, the color of other rows will change accordingly.įor changing column colors, you should choose “Odd banded columns” and “Even banded columns” in “Apply formatting to”. Select the table and choose the style, then you will have it on your table. Now you can find the new style in “Table Styles” gallery.
Now, you can choose a storage location for the new style, by selecting either “Only in this document” or “New documents based on this template”.
Again, in “Creating New Style from Formatting” dialog box, this time you choose “Even banded rows”.
Now you are back to “Creating New Style from Formatting” dialog box, choose “Odd banded rows” for “Apply formatting to”.
Then click “Shading” and choose a color for “Fill”.
Now in “Borders and Shading” dialog box, fist click “Borders” to choose whatever setting you need.
And click “Format” button on the left down side.
Then, choose “Header row” for “Apply formatting to”.
And the same way can be employed to alter column color. Note: In the following example, we will demonstrate the way to set different colors for odd and even rows.
Next, in “Creating New Style from Formatting” dialog box, name the new style first.
And choose “New Table Style” on the drop-down menu.
Next click “More” button in “Table Styles” group.
For example, we should choose “Header Rows”, “Banded Rows” and “Banded Columns”.
Go to “Table Style Options” group to check options first.
Then, click “Design” tab under “Table Tools”.
Firstly, select the entire target table.
Following are details: Method 1: Create a New Table Style But now, we have 2 awesome ways to deal with such an issue that is to apply different colors for odd and even rows or columns. When it comes to a long table, we always find it pretty tiresome to stare at those numbers and try so hard not to make a mistake. In this article, we will introduce 2 methods for you to alternate row or column colors in your Word table.
0 kommentar(er)
