BackColor Property [Worksheet Document]

The BackColor property returns or sets the worksheet cell background color. A null is returned if all the cells in a range do not have the same background color. Returns a variant.

Syntax

object.BackColor

object.BackColor = Color

Remarks

Use the enumeration [wksColorRed], RGB value [RGB(255,0,0)], or number [255] to set a color.

Example 1

This example demonstrates how to return the background color of a cell.

Debug.Print WksCellFormat. BackColor

Example 2

This example demonstrates how to change the background color of a cell to chalk.

WksCellFormat.BackColor = wksColorChalk

Used by: WksCellFormat object