Updated: November 17, 2026

If you want Google Sheets to make a cell change color automatically, the tool you need is conditional formatting. It lets a cell fill with a color when its value matches a rule, such as text, numbers, dates, or a formula result. That is the simplest way to turn a manual formatting task into an automatic one.

Use conditional formatting to change cell color with a formula

A formula-based rule is the direct answer to a Google Sheets cell color formula request. Instead of coloring a cell by hand, you tell Sheets what condition to check, then choose the fill color you want. This works for one cell, a range, a whole row, or a whole column.

  1. Select the cells you want to format.
  2. Open Format, then Conditional formatting.
  3. Under Format rules, open the drop-down and choose Custom formula is.
  4. Enter a formula that returns TRUE for the cells you want colored.
  5. Pick the fill color under Formatting style.
  6. Click Done.

Example: color a cell when another cell contains text

If you want a row to turn green when column B says Done, use a formula like =B2=”Done”. Select the row range first, then apply the rule to that range. Sheets will evaluate each row separately and color the matching rows based on the text in column B.

Example: color a cell when a number meets a condition

If you want cells in column C to turn red when the value is less than 10, select the range and use =C2<10. The key is to write the formula as if it starts in the top-left cell of the selected range. Sheets adjusts the reference as it applies the rule down the range.

How to change cell color based on text, number, or date

Most people searching for how to change the color of a cell in Google Sheets want three things, text rules, number rules, and date rules. All three work the same way once you open conditional formatting. The only difference is the formula or rule you choose.

Change cell color based on text

For text, use an exact match rule or a formula. Exact match is best when the cell should color only when it contains one specific word, such as Approved, Late, or Shipped. Use Text is exactly for a quick setup, or use Custom formula is if you want more control, such as checking text in another column.

Change cell color based on a date

For dates, use rules like Date is before, Date is after, or a custom formula with TODAY(). For example, if due dates are in column D, =D2<TODAY() colors overdue items. That is the cleanest way to make overdue tasks stand out without changing the data itself.

Change cell color based on a value range

For numbers, use thresholds such as greater than, less than, or between. This is useful for budgets, scores, stock counts, and progress tracking. If you need multiple colors, add multiple conditional formatting rules to the same range, one rule per color band.

How to use alternating colors in Google Sheets

Alternating colors are different from conditional formatting. They create striped rows or columns for readability, not logic-based coloring. If your goal is to make Google Sheets alternate colors every 2 rows or apply a simple banded layout, use the built-in alternating colors feature instead of a formula.

  1. Select the range you want striped.
  2. Open Format, then Alternating colors.
  3. Choose a preset style or set custom header, first color, and second color.
  4. Click Done.

How to alternate row colors in Google Sheets

To alternate row colors in Google Sheets, select the full table range, including headers if you have them. Then apply alternating colors and choose whether the first row is a header. Sheets will shade every other row automatically. This is the fastest method for making long sheets easier to scan.

How to alternate colors in columns

Alternating colors can also run vertically. If you want column stripes instead of row stripes, choose the column-based option in the alternating colors panel or apply the banding to a range arranged by columns. This helps when you are comparing horizontal data, such as monthly columns or category columns.

Alternating colors every 2 rows

If you want a stronger pattern, set the banding so the color repeats every 2 rows across the selected range. In Google Sheets, that means using the default alternating pattern on a range that starts and ends where you want the stripe sequence to apply. For a standard two-color table, the built-in alternating colors tool handles this without a formula.

Fix alternating colors not working or remove them

If Google Sheets alternating colors is not working, the problem is usually the selected range or overlapping formatting. A manual fill color on a cell can hide the banding, and a partial selection can make the pattern look broken. Remove the conflict, then reapply the banding to the full range.

Why alternating colors stop showing correctly

Alternating colors disappear when cells already have manual fill colors, when rows are inserted outside the banded range, or when the sheet has mixed formatting across the table. If the stripes look uneven, clear the manual fill from the affected cells and reopen the alternating colors panel to expand the range if needed.

How to remove alternating colors

To remove alternating colors, select the banded range, open Format, then Alternating colors, and click Remove alternating colors. That deletes the banding rule and restores the cells to their normal background. It does not remove other formatting such as borders, text color, or bold text.

Use formulas for more advanced color rules

Conditional formatting becomes powerful when you use a formula instead of a simple dropdown rule. This is the best answer for searches like Google Sheets set cell color formula or Google Sheets fill color formula, because formulas let you color cells based on logic across multiple columns, repeated labels, blanks, and duplicates.

Color an entire row based on one cell

If column E contains the status, and you want the whole row colored when the status is Complete, select the full table range and use a custom formula such as =$E2=”Complete”. The dollar sign locks the column, so each row checks its own E cell while the formatting spreads across the selected row range.

Color blanks, duplicates, or matched text

You can also color blanks with =A2=””, duplicates with a duplicate-check formula, or matching text with =REGEXMATCH(A2,”urgent|high”). This gives you precise control when built-in options do not cover the rule you want. The rule can color the cell, the row, or even a block of cells tied to the same record.

Change the default cell colour

Google Sheets does not have a global default cell color formula setting that changes new cells automatically across every sheet. What you can do is format a range, copy the format, or use conditional formatting rules on the ranges you care about. If you want a repeated look across a workbook, use templates or apply the same formatting rules to each sheet.

Frequently Asked Questions

What is the fastest way to make a cell change color in Google Sheets?

Use conditional formatting. Select the range, open Format, then Conditional formatting, choose a rule or custom formula, and set the fill color. That is the quickest way to make Google Sheets change cell color automatically.

Can I color a cell based on text in another cell?

Yes. Use Custom formula is and reference the other cell, such as =B2=”Done”. Apply the rule to the range you want colored, and Sheets will evaluate each row against the text in that referenced cell.

How do I make Google Sheets alternate colors every 2 rows?

Select the range, then use Format and Alternating colors. Google Sheets applies the two-row banding pattern automatically across the selected table. If the pattern looks off, the range selection is incomplete or existing fill colors are overriding it.

How do I remove alternating colors from a sheet?

Select the banded range, open Format, then Alternating colors, and choose Remove alternating colors. That removes the banding rule and returns the cells to their normal background.

Can I use a formula to change the fill color of a cell?

Yes, through conditional formatting. The formula does not paint the cell directly, it controls a formatting rule that changes the fill color when the formula returns TRUE. That is how Google Sheets handles formula-based cell coloring.

Why is my alternating row color not showing on new rows?

The banded range stops where it was originally applied. Open the alternating colors settings and extend the range to include the new rows, or reapply the banding to the full table.