View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?