How to Add Color to Cells in Google Sheets

Adding color to cells in Google Sheets makes headers stand out, groups related data, and helps you spot important values at a glance. You can color cells manually with the fill color tool, color them automatically based on their values with conditional formatting, or band rows with alternating colors. This guide covers all three on a computer and in the mobile app, plus tips for a clean, readable color scheme.

Quick Answer

Select the cells, click the Fill color (paint bucket) button on the toolbar, and choose a color. For custom colors, click + under Custom. To color cells automatically, use Format > Conditional formatting.

Add a Fill Color to Cells

1. Select the cells, row or column. Click a row number or column letter to select all of it.
2. Click the Fill color button (paint bucket) on the toolbar.
3. Click a color in the palette.

To use an exact brand color, click + under Custom, enter a hex code (such as #D9EAD3) or pick a color, and click OK. Custom colors are saved in the palette for that spreadsheet.

Change Text Color

Select the cells and click the Text color button (the underlined A) to change font color. Dark text on light fills, or white text on dark fills, keeps things readable.

Color Cells Automatically With Conditional Formatting

1. Select the range, for example a Status column.
2. Click Format > Conditional formatting.
3. Under Format rules, choose a condition, such as Text is exactly “Done,” Greater than 100, or Date is before today.
4. Pick a fill color (and text color) under Formatting style.
5. Click Done. Add more rules with Add another rule.

For a gradient that shades cells by value, choose the Color scale tab in the same panel. To color whole rows based on one column, use Custom formula is with a formula like =$C2="Done" applied to A2:C100.

Band Rows With Alternating Colors

1. Click any cell in your data.
2. Choose Format > Alternating colors.
3. Pick a default style or customize the header, color 1 and color 2, then click Done.

Color Cells in the Google Sheets App

1. Select the cells and tap the Format icon (A with lines).
2. On the Cell tab, tap Fill color and pick a color.
3. For rules, tap the three dots > Conditional formatting.

Tips for Using Color Well

• Stick to a few light colors with consistent meanings, such as green for done and yellow for pending.
• Add a legend row explaining the colors.
• Don’t rely on color alone; add text labels for people with color vision differences.
• Use Format painter (the paint roller) to copy colors to other cells.
• To remove colors, choose Fill color > Reset. See how to remove cell shading in Google Sheets.

Frequently Asked Questions

Can I filter or sort by color?

Yes. Create a filter (Data > Create a filter), click the filter icon, and choose Filter by color or Sort by color.

Can I count colored cells?

Not with a built-in function. Filter by color and check the count in the status bar, or count based on the rule that sets the color with COUNTIF.

Why won’t my color change?

A conditional formatting rule or alternating colors may override manual fills. Check Format > Conditional formatting.

Summary

1. Select cells and click Fill color.
2. Pick a color or add a custom one.
3. Use conditional formatting to color by value.
4. Use alternating colors for banded rows.