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

Hi,

If you are using Excel 2003 or earlier you can use Format, Conditional
Formatting but you are limited to three conditions. To get around that you
would need to use VBA.

In Excel 2007 the Conditional Formatting is limited only by memory so you
can handle as many colors as you want.

In 2003 you would select the cells you want formatted and choose Format,
Conditional Formatting, in the second box you would choose Equal to, in the
third box type Red, then click Format, and on the Patterns tab pick red.
Click OK once and then Add. Proceed as above.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"T-DOGG01" wrote:

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

Sir,

Thank you so much. That was a tremendous help and I am really greatful for
your assistance. Again Thank you.!!!!!!
--
T-DOGG01


"ShaneDevenshire" wrote:

Hi,

If you are using Excel 2003 or earlier you can use Format, Conditional
Formatting but you are limited to three conditions. To get around that you
would need to use VBA.

In Excel 2007 the Conditional Formatting is limited only by memory so you
can handle as many colors as you want.

In 2003 you would select the cells you want formatted and choose Format,
Conditional Formatting, in the second box you would choose Equal to, in the
third box type Red, then click Format, and on the Patterns tab pick red.
Click OK once and then Add. Proceed as above.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"T-DOGG01" wrote:

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

You welcome,
--

Shane Devenshire


"T-DOGG01" wrote:

Sir,

Thank you so much. That was a tremendous help and I am really greatful for
your assistance. Again Thank you.!!!!!!
--
T-DOGG01


"ShaneDevenshire" wrote:

Hi,

If you are using Excel 2003 or earlier you can use Format, Conditional
Formatting but you are limited to three conditions. To get around that you
would need to use VBA.

In Excel 2007 the Conditional Formatting is limited only by memory so you
can handle as many colors as you want.

In 2003 you would select the cells you want formatted and choose Format,
Conditional Formatting, in the second box you would choose Equal to, in the
third box type Red, then click Format, and on the Patterns tab pick red.
Click OK once and then Add. Proceed as above.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"T-DOGG01" wrote:

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