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?
|