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

robert wake;244700 Wrote:
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

Go to Format - Conditional formatting - Change to "Formula is" enter
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 green


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68241

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

"robert wake" wrote:

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

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

"robert wake" wrote:

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