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

[Guest]

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?

 

[T. Valko]

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 Format>Conditional Formatting
Formula Is: =A1="Biff"
Click the Format button
Select the Patterns tab
Select black
OK out

Biff

 

[Guest]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

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