0

I want the cell to turn green when I type in "win" or red when I type in "lost". How do I do that?

I tried with Conditional formatting but I was only able to do it for one word value. There was no "if" win then green or "if" lost then red.

Thanks! Tine

1 Answer 1

3

You can set several rules for Conditional Formatting within the same set of cells. Just create another condition, as you did for the "win" one :

  • If "win" => green
  • If "lost" => red

The format of the first hit rule will be applied to your cell.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .