Make an Excel Cell Change Color Based on Another Cell
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.

- 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.
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.
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.
Click A2, the cell you want to change color based on A1.
Go to Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format.
In the formula box, enter =(A1="work"). Replace the text or reference if the source cell uses a different condition.
Click Format, open the Fill tab, choose green or another color, and click OK. Click OK again to save the rule.

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. Open the spreadsheet: Open WPS Spreadsheets and select File > Open to open your workbook.
- 2. Select the target: Click A2, or select the range where you want the formatting to appear.
- 3. Create the rule: Go to Home > Conditional Formatting > New Rule and choose the option to use a formula.
- 4. Set the condition and fill: Enter =(A1="work"), choose a green fill in the format settings, and confirm the rule.

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.




