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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T-DOGG01 - 25 May 2008 21:45 GMT

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?

Signature

T-DOGG01

Reply to this Message

David Biddulph - 25 May 2008 21:50 GMT

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

>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?

Reply to this Message

T-DOGG01 - 25 May 2008 22:06 GMT

David,

Thanks. I think I found the soulution.

Signature

T-DOGG01

> Not a formula, but Conditional Formatting.
> --
[quoted text clipped - 6 lines]
> > the
> > word "red" how can I make that cell's background that color? Or that row?

Reply to this Message