Formatting Issues

Make an Excel Cell Change Color Based on Another Cell

Jason MillerJason Miller Nov 18, 2026 868 views

Question details

Make one Excel cell change color when another cell meets the condition that makes it green, without using VBA or reading its displayed color.

Make an Excel Cell Change Color Based on Another Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants a target cell to follow the same condition as another cell that is formatted green.
Observed behavior
The target cell should display the chosen color whenever the source cell meets the specified condition.
Before you start

Identify the condition that makes the source cell green, such as A1 containing the text work. If the source cell already uses conditional formatting, select it and open Home > Conditional Formatting > Manage Rules to inspect the rule.

Solution 1Recommended

Reuse the source cell's condition in a formula rule

Use this method when the source cell is green because of a known value or conditional formatting rule.

A formula-based rule evaluates the underlying condition, not the source cell's displayed fill color. This example assumes A1 turns green when it contains work.

1
Select the target cell

Click A2, the cell you want to change color based on A1.

2
Create a formula rule

Go to Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format.

3
Enter the condition

In the formula box, enter =(A1="work"). Replace the text or reference if the source cell uses a different condition.

4
Choose the fill

Click Format, open the Fill tab, choose green or another color, and click OK. Click OK again to save the rule.

Reuse the source cell's condition in a formula rule
Apply the rule to a range: To make every cell in A2:A100 respond to A1, select A2:A100 and use =(A$1="work"). The dollar sign fixes the reference to row 1. To check a different source cell in each row, select A2:A100 and use =($B2="work") to check B2 through B100.
Conditional formatting in WPS Spreadsheets

Color Cells Based on Another Cell in WPS Spreadsheets

Use a formula-based conditional formatting rule in WPS Spreadsheets to apply a fill when another cell meets the same condition.

  1. 1. Open the spreadsheet: Open WPS Spreadsheets and select File > Open to open your workbook.
  2. 2. Select the target: Click A2, or select the range where you want the formatting to appear.
  3. 3. Create the rule: Go to Home > Conditional Formatting > New Rule and choose the option to use a formula.
  4. 4. Set the condition and fill: Enter =(A1="work"), choose a green fill in the format settings, and confirm the rule.
Apply a cell color based on another cell's value without VBA.Use relative and absolute references to apply rules across a range.Open and save Microsoft Excel XLSX files.Work in a familiar spreadsheet interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can a conditional formatting formula detect a manually applied green fill?

A standard conditional formatting formula does not directly read another cell's fill color. Instead, use the value or condition that determines when the source cell should be green.

How do I make an entire range respond to A1?

Select A2:A100, create a formula-based conditional formatting rule, and enter =(A$1="work"). The fixed row reference makes each selected cell check A1.

How can each row check a different source cell?

Select A2:A100 and create a formula rule using =($B2="work"). Excel adjusts the row reference so A2 checks B2, A3 checks B3, and so on.

Where can I find the condition that makes a cell green?

Select the green cell in Excel, then go to Home > Conditional Formatting > Manage Rules. Inspect the applicable rule and reuse its condition with the appropriate cell reference.