Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome. Thanks for the feedback!
Biff "LV" wrote in message ... 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? |
Reply |
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) |