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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

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?
 

Forum statistics

Threads
1,141,665
Messages
5,707,712
Members
421,524
Latest member
Bharath99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top