I'm creating a form in EXCEL where based on a choice from a drop down in one
list, certain cells get blacked-out (so they don't get filled out). How do I
do this?

You can use conditional formatting.

Suppose cell A1 is the drop down list. If the drop down list selection is
Biff then black-out cell B1.

Select cell B1
Goto the menu FormatConditional Formatting
Formula Is: =A1="Biff"
Click the Format button
Select the Patterns tab
Select black
OK out

Biff

"LV" wrote in message
...
I'm creating a form in EXCEL where based on a choice from a drop down in
one
list, certain cells get blacked-out (so they don't get filled out). How
do I
do this?

That is awesome and it worked nicely! THANK YOU SO MUCH!!!!!!!! You rock!

"T. Valko" wrote:

You can use conditional formatting.

Suppose cell A1 is the drop down list. If the drop down list selection is
Biff then black-out cell B1.

Select cell B1
Goto the menu FormatConditional Formatting
Formula Is: =A1="Biff"
Click the Format button
Select the Patterns tab
Select black
OK out

Biff

"LV" wrote in message
...
I'm creating a form in EXCEL where based on a choice from a drop down in
one
list, certain cells get blacked-out (so they don't get filled out). How
do I
do this?

You're welcome. Thanks for the feedback!

Biff

"LV" wrote in message
...
That is awesome and it worked nicely! THANK YOU SO MUCH!!!!!!!! You
rock!

"T. Valko" wrote:

You can use conditional formatting.

Suppose cell A1 is the drop down list. If the drop down list selection is
Biff then black-out cell B1.

Select cell B1
Goto the menu FormatConditional Formatting
Formula Is: =A1="Biff"
Click the Format button
Select the Patterns tab
Select black
OK out

Biff

"LV" wrote in message
...
I'm creating a form in EXCEL where based on a choice from a drop down
in
one
list, certain cells get blacked-out (so they don't get filled out).
How
do I
do this?