How To Change Cell Color In Excel

Y'all can highlight data in cells past using Make full Colour to add or change the background colour or pattern of cells. Here's how:

Select the cells you want to highlight.
Tips:
- To use a different background color for the whole worksheet, click the Select All button. This volition hide the gridlines, merely you tin improve worksheet readability by displaying cell borders around all cells.
Click Home > the arrow next to Fill Colour , or press Alt+H, H.
Under Theme Colors or Standard Colors, pick the colour you want.

To use a custom colour, click More Colors, and so in the Colors dialog box select the color you want.

Tip:To apply the about recently selected color, you lot tin merely click Fill Color . Yous'll also discover upwards to 10 most recently selected custom colors nether Recent Colors.

Apply a pattern or fill furnishings

When you want something more than a just a solid colour fill, try applying a design or fill effects.

Select the cell or range of cells you want to format.
Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F.
On the Make full tab, under Groundwork Color, pick the colour y'all want.
To use a pattern with two colors, choice a color in the Pattern Color box, and and then pick a pattern in the Design Way box.

To apply a design with special effects, click Fill Furnishings, and then pick the options yous want.

Tip:In the Sample box, yous tin preview the background, pattern, and make full furnishings you lot selected.

Remove cell colors, patterns, or fill up effects

To remove whatever groundwork colors, patterns, or make full effects from cells, simply select the cells. Then click Home > arrow side by side to Fill up Colour, and and so option No Make full.

Font group on the Home tab

Print cell colors, patterns, or fill effects in color

If print options are set to Blackness and white or Draft quality — either on purpose, or because the workbook has big or circuitous worksheets and charts that caused draft fashion to exist turned on automatically — cells won't print in color. Here'south how you can fix that:

Click Page Layout > Folio Setup dialog box launcher.
On the Canvass tab, under Print, uncheck the Black and white and Draft quality check boxes.

Note:If you lot don't see colors in your worksheet, it may be that you're working in high contrast mode. If you don't run into colors when you preview earlier yous print, information technology may exist that y'all don't take a colour printer selected.

If you'd similar to highlight text or numbers to make the data more than visible, try either irresolute the font colour or add a groundwork color to the cell or range of cells similar this:

sample of text color and cell background fill applied

Select the jail cell or range of cells for which y'all want to add a fill color.
On the Home tab, click Fill Color, and choice the color you desire.

Notation:Pattern fill effects for groundwork colors are non bachelor for Excel for the spider web. If you apply whatsoever from Excel on your desktop, it won't appear in the browser.

Remove fill color

If y'all determine that yous don't desire the fill color immediately later yous added it, just click Disengage .

The button to undo an action

To remove the fill up color at a later on time, select the cell or jail cell range you desire to change, and click Clear > Articulate Formats.

use the clear format button to remove formatting