Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make coloured drop down lists in Excel?
I want to create drop down lists within excel. The list needs to contain
colours only as the colours represent specific items. Is this possible? And if so, could someone please give me the formula required or a step by step guide on how to do it. Cheers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make coloured drop down lists in Excel?
In F1 thru F6, enter:
red green blue orange brown yellow then in another cell: Data Validation Allow List to make the drop down -- Gary''s Student - gsnu200855 "ÉannaD" wrote: I want to create drop down lists within excel. The list needs to contain colours only as the colours represent specific items. Is this possible? And if so, could someone please give me the formula required or a step by step guide on how to do it. Cheers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make coloured drop down lists in Excel?
The below link will help
http://contextures.com/xlDataVal10.html#Create If this post helps click Yes --------------- Jacob Skaria "ÉannaD" wrote: I want to create drop down lists within excel. The list needs to contain colours only as the colours represent specific items. Is this possible? And if so, could someone please give me the formula required or a step by step guide on how to do it. Cheers |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make coloured drop down lists in Excel?
You cannot color the cells to select from in a dropdown list .
You can color the item selected using Conditional Formatting but that's all. Gord Dibben MS Excel MVP On Wed, 27 May 2009 00:56:01 -0700, ÉannaD wrote: I want to create drop down lists within excel. The list needs to contain colours only as the colours represent specific items. Is this possible? And if so, could someone please give me the formula required or a step by step guide on how to do it. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to make multiple drop down lists that excludes cell in a ra | Excel Discussion (Misc queries) | |||
Drop down lists in excel | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
how do I make the cursor appear as a coloured outline box? | Excel Discussion (Misc queries) | |||
Drop down lists are displaying end of list, how to make it top? | Excel Worksheet Functions |