Trying to change the background of a cell if I type a certain word
 

I am creating an Equipment Status worksheet for my job. Is there a formula
that I can use to change the background color of a paticular cell if I type
the word of that paticular color in it? I.E. in the status column I type the
word "red" how can I make that cell's background that color? Or that row?

--
T-DOGG01

Trying to change the background of a cell if I type a certain word
 

See replies at your other posts

--
Biff
Microsoft Excel MVP


"T-DOGG01" wrote in message
...
I am creating an Equipment Status worksheet for my job. Is there a formula
that I can use to change the background color of a paticular cell if I
type
the word of that paticular color in it? I.E. in the status column I type
the
word "red" how can I make that cell's background that color? Or that row?

--
T-DOGG01