Changing color inside a cell or range
Initially, all the cells in your worksheet are transparent (without a background color), and the color of all text and numbers you enter is black. You can change the background color and text color in a selected cell or range.
- Select the cell or range you want to change.
- In the action bar, click Lines & Colors.
- Click Background color and choose a background color for the selected range.
- Click Text color and choose a color for the selected text.
Your changes take effect immediately.
- To close the pop-up panel, click
.
Keeping a selected cell or range transparent
If you have assigned a background color to a range, you can still keep a selected cell or range transparent (without a background color) within the colored area.
- Select the cell or range you want to keep transparent.
- In the action bar, click Lines & Colors.
- Click Transparent.
A check mark appears in the box, and your change takes effect immediately.
- To close the pop-up panel, click
.
See also
Aligning data
Changing the appearance of text
Changing how range borders look
Inserting a background graphic for a worksheet