Forum Discussion

edelvizio's avatar
edelvizio
Copper Contributor
Aug 30, 2023
Solved

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 ...
  • HansVogelaar's avatar
    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.

Resources