Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to change the background of a cell if I type a certain word
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to change the background of a cell if I type a certain
David,
Thanks. I think I found the soulution. -- T-DOGG01 "David Biddulph" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I type a word in a cell, tab out and it changes | New Users to Excel | |||
Change Cell background color by selection | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
I want to type the letter Y in a cell and have the word Yes appea. | New Users to Excel | |||
background color of my cell does not change | Excel Discussion (Misc queries) |