software

I need for each cell in a particular column, to populate ONLY with the
choices given in a scroll down menu for each cell in that column. The column
is entitled quot;Project Statusquot; and the only word choices that should populate
this cell, which are to be chosen from a scroll down menu, a Completed, On
Track, Postponed, Behind.

Thanks for your help. mj

Try Data Validation:

Select ALL of the Project Status input cells
lt;datagt;lt;validationgt;
Allow: List
Source: Completed,On Track,Postponed,Behind
Click the [OK] button

Now, those cells will only allow the listed items.

For more information on Data Validation, see Debra Dalgleish's website:
www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;Maryjerkquot; wrote:

gt; I need for each cell in a particular column, to populate ONLY with the
gt; choices given in a scroll down menu for each cell in that column. The column
gt; is entitled quot;Project Statusquot; and the only word choices that should populate
gt; this cell, which are to be chosen from a scroll down menu, a Completed, On
gt; Track, Postponed, Behind.
gt;
gt; Thanks for your help. mj

Ron -

You are a Rock Star. Thanks so much as that worked beautifully. I'm much
more proficient at MS Word and PP, and only an average Excel user, so the
quick response and the great dirrection are MUCH appreciated.

Is it possible to take this one step further? I'd like for the words On
Track, Ongoing, and Completed to appear in Green, and for the words Behind
Schedule and Postponed to appear in red. I know there is a way to do this
automatically with values, but I'm at a loss as to how to do this in my
present situation. Any further advice is greatly appreciated.

MJ

quot;Maryjerkquot; wrote:

gt; I need for each cell in a particular column, to populate ONLY with the
gt; choices given in a scroll down menu for each cell in that column. The column
gt; is entitled quot;Project Statusquot; and the only word choices that should populate
gt; this cell, which are to be chosen from a scroll down menu, a Completed, On
gt; Track, Postponed, Behind.
gt;
gt; Thanks for your help. mj

Try Conditional Formatting:

Assuming you want the formatting to impact A1:A50

1)Just fomat the cells to show Green text.
That will cover these values: On Track, Ongoing, and Completed

2)Set the CF to cover the Behind Schedule and Postponed values...

Select the A1:A50, with A1 as the Active Cell
lt;formatgt;lt;conditional formattinggt;
Formula is: =or(A1=quot;Behind Schedulequot;,A1=quot;Postponedquot;)
Click the [Format] button and set the format (red text)
Click the [OK] buttons

Using the above, the green font will be used, unless the cell value is
quot;Behind Schedulequot; or quot;Postponedquot;.

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;Maryjerkquot; wrote:

gt; Ron -
gt;
gt; You are a Rock Star. Thanks so much as that worked beautifully. I'm much
gt; more proficient at MS Word and PP, and only an average Excel user, so the
gt; quick response and the great dirrection are MUCH appreciated.
gt;
gt; Is it possible to take this one step further? I'd like for the words On
gt; Track, Ongoing, and Completed to appear in Green, and for the words Behind
gt; Schedule and Postponed to appear in red. I know there is a way to do this
gt; automatically with values, but I'm at a loss as to how to do this in my
gt; present situation. Any further advice is greatly appreciated.
gt;
gt; MJ
gt;
gt; quot;Maryjerkquot; wrote:
gt;
gt; gt; I need for each cell in a particular column, to populate ONLY with the
gt; gt; choices given in a scroll down menu for each cell in that column. The column
gt; gt; is entitled quot;Project Statusquot; and the only word choices that should populate
gt; gt; this cell, which are to be chosen from a scroll down menu, a Completed, On
gt; gt; Track, Postponed, Behind.
gt; gt;
gt; gt; Thanks for your help. mj