Auto adjust cell color, if another set of cells has a specifc text

I want a cell to be colored according to the result of another Excel cell, is it possible? For example, a certain set of cells (say cells B1 to L1) turn red or green because the text of another cell ...

excel

Formulas and Functions

HansVogelaar
Aug 30, 2023
edelvizio

Select B1:L1 (or more rows in columns B to L if you wish).

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=$A1="text1"

Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.

Repeat these steps with the formula

=$A1="text2"

and red as fill color.

HansVogelaar

MVP

Aug 30, 2023

edelvizio

Select B1:L1 (or more rows in columns B to L if you wish).

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=$A1="text1"

Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.

Repeat these steps with the formula

=$A1="text2"

and red as fill color.