how to change color of cell based on contents of cell

[robert wake]

how do i change the color of a cell based on the contents of the cell. ex.
when the cell says stop the color of the cell turns red, when contents go
turns to green

 

[Pecoflyer]

how do i change the color of a cell based on the contents of the cell
ex.
when the cell says stop the color of the cell turns red, when content
go
turns to green

Go to Format - Conditional formatting - Change to "Formula is" ente
a1="red" ( if the cell is a1 - set your pattern to red
click and and to the same for a1="green" and set pattern to gree

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Eduardo]

Hi Robert,
use conditional formation, where the formula is and there you enter ="Stop"
and choose the red color, then enter another formula which will be
="Go" and choose the color green

 

[Eduardo]

OPPs I didn't include the cell
Suppose the cell that contains Stop and Go is A1 so the formulas will be

A1="Stop" red color
A1="Go" Green color