HOW TO? Per choice in a list, certain cells become blacked out.
 

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?

HOW TO? Per choice in a list, certain cells become blacked out.
 

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?

HOW TO? Per choice in a list, certain cells become blacked out
 

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?

HOW TO? Per choice in a list, certain cells become blacked out
 

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?