View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
LV LV is offline
external usenet poster
 
Posts: 6
Default 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?