Not a formula, but Conditional Formatting.
--
David Biddulph

"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