Change cell background color word how to#

Range.EndUpdateFormatting(rangeFormatting) Worksheet.Cells('A1').FillColor = Color.Yellowĭim range As CellRange = worksheet.Range('C3:D4')ĭim rangeFormatting As Formatting = range.BeginUpdateFormatting() For example, to change the background of the first cell in the first table in the active document, you can use: 1.Cell(1,1).Shading Please let me know if you have any questions. Worksheet.Cells('A1').Font.Color = Color.Red Hi Viswa, You can use the Shading object of the Cell. = Color.Yellow ĬellRange range = worksheet.Range įormatting rangeFormatting = range.BeginUpdateFormatting() The following example specifies font and background colors for an individual cell and cell range: To share font color and background settings with multiple cells in a single step, create or modify a style with the Formatting.Font and Formatting.Fill properties specified as required, and assign this style to CellRange.Style for the desired cells. Fill.PatternColor - sets the shading color for a cell.The available pattern types are accessed via the PatternType enumeration members. Fill.PatternType - sets the type of cell background pattern.It is also available via the CellRange.FillColor property of the cell or cell range object. Fill.BackgroundColor - sets the cell background color.Use the following properties of this object to set cell background. The Formatting.Fill property returns the Fill object. Under Theme Colors or Standard Colors, pick the color you want. Click Home > the arrow next to Fill Color, or press Alt+H, H. Tips: To use a different background color for the whole worksheet, click the. Set this object’s SpreadsheetFont.Color property to the required Color value to change cell font color. Heres how: Select the cells you want to highlight. The Formatting.Font property returns the SpreadsheetFont object. To change color characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Font and Fill properties of the returned Formatting object and call the CellRange.EndUpdateFormatting method to finalize the modification. The steps in this section are pretty similar to the ones that we used to change the border, or gridline, color in our table.

Change cell background color word how to#

How to Change Table Background Color in Word 2013. Therefore, click on Highlight cell rules and Less than. If you are trying to change the color of your table’s background instead, then the next section will show you how. For our example, we want to mark cells with a value less than zero with a red background color. To specify these attributes for an individual cell, modify the Cell object’s Formatting.Font and Formatting.Fill properties, which are inherited form the Formatting interface. This function allows you to change colors of cells based on their value: You can choose between Less than, Greater than, Between and many more options. You can change cell font color and cell background. How to: Change Cell Font and Background Color