Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
Row blacked out | Excel Discussion (Misc queries) | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
Forcing value based on list choice?? | Excel Discussion (Misc queries) | |||
Dropdown list/Multiple choice?? | Excel Discussion (Misc queries) |