fill effect for chart cell background color word 2016

#FILL EFFECT FOR CHART CELL BACKGROUND COLOR WORD 2016 HOW TO#

Here, you can select from a much larger palette of colors, click on the Custom Tab to find even more colors, or set the transparency level, which we'll talk about a little further on. You will see 40 colors presented as well as the option for More Fill Colors and Fill Effects.

Now find the paint can icon on your Drawing Toolbar and click it. Basic ColorsĬreate a basic shape and then select it.

Because I'm using Excel as my example, here's a link to the Excel Drawing Toolbar tutorial.

#FILL EFFECT FOR CHART CELL BACKGROUND COLOR WORD 2016 HOW TO#

I'm making the assumption that you already know how to use the Drawing Toolbar to create basic shapes. The main body text in a Word document acts the same way. While this may seem odd, I'm doing this because the majority of the data in Excel resides on the bottom layer (the actual cells), so any shapes you layer on top of it, will cover up your data if you're not careful. I'm going to use Excel as my base application for the discussion and examples. There are a ton of options in how to format shapes with color and textures, but you need to understand how drawing items interact to one another to enhance or occlude your message. Sometimes you just don't want to use the same boring color default color palette for your shapes that comes with the Office Suite of products. All you need to do is make sure you place the insertion point somewhere within the table before running it.Tips for Excel, Word, PowerPoint and Other Applications Fill Colors in the Office Suite Why It Matters To You The macro shades an entire table based on the shading used in the first cell of the first row of the table. MsgBox 'Put the insertion point in a table' Shading.ForegroundPatternColor = foreColor Shading.BackgroundPatternColor = backColor Cell(1, 1).Shading.ForegroundPatternColor Cell(1, 1).Shading.BackgroundPatternColorįoreColor =. If Selection.Information(wdWithInTable) ThenīackColor =. If you need to do this quite a bit with a number of tables or in a number of documents, you may want to consider using a macro to do the shading. The shading is repeated on the selected cells. Your desired color is applied to the selected rows.Īfter you apply the desired color, if you want to apply it elsewhere (perhaps in another table or in some cells you missed), all you need to do is select the cells and press F4. Click on the Shading tool on the Design tab of the ribbon.Select the other rows in the table whose background color you want to change.(Note that you made no changes in the dialog box you just clicked OK.) The color of the selected row should already show in the dialog box. (The tool looks like a spilling bucket of paint.) Word displays a palette of colors. Click the down-arrow to the right of the Shading tool, in the Paragraph group.Select the row that is already filled with the desired color.One is to simply use the tools that are available in Word. There are a few ways that you can approach this issue. April wonders if there is a way to copy the fill color from one row to another. She was hoping to use the Format Painter, but that just copies the text format, not the fill color used in the table cells. April now wants to copy that fill color to other rows. One row is formatted with a custom color fill to match the company's logo color.

Fill effect for chart cell background color word 2016