set row format according to pick list selection

saturdaygig

New Member
Joined
Aug 1, 2002
Messages
22
I have a list of projects, and the second column contains a pick list (drawn from a range on sheet 2) of project solution types. These types can be changed during the life of the project.

Each project has a set of milestone and activity start/end dates which are defined by the project type selected in col 2. I want these to be automatically set up when the project type is selected. Right away I can see two ways to do it although I don't know how to code either.

1. Have all possible date headings strung out accross the top row, and have the irrelevant ones grey out when a project type is selected. I guess this can be done by setting up standard grey-out cells on sheet 2 for each type, and some sort of conditional format code.

2. Have a different sheet (or section of one sheet) for each project type
with the headings already defined. Make the project row jump to the right area when the type is selected from the drop down.

3. Any other way you can think of.

Project_Type_date1____date2___date3__date4
1______a___required__required__not___not
2______b___not______required__not____required
3______b___not______required__not____required
4______a___required__required__not____not
5______c___required__not______ not____not

sorry its a bit complicated, I hope I succeeded in explaining the adequately.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

saturdaygig

New Member
Joined
Aug 1, 2002
Messages
22
I hope I won't offend anyone by giving myself a bump. Just hoping for an answer - is the explanation OK?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,679
Members
410,697
Latest member
srishtijain0708
Top