Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofil color to a row from dropdown list choices
I am trying to autofil certain colors to rows that have dropdown choices.
Each choice will be assigned a certain color. |
#2
|
|||
|
|||
Alesia
That would depend upon how many choices you have. Conditional Formatting will give you 3 choices(4 if you count the default) although JE McGimpsey has a method to give 6 if you are entering numerics. For more you could use event code. The drop-downs you could create using Data Validation. Post back with more details. I'm sure we can get you sorted. Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:51:04 -0800, Alesia wrote: I am trying to autofil certain colors to rows that have dropdown choices. Each choice will be assigned a certain color. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-building dropdown list | Excel Worksheet Functions | |||
creating a dropdown list in excel | Excel Discussion (Misc queries) | |||
Use dropdown list from Form | Excel Discussion (Misc queries) | |||
How do I add a dropdown list in a spreadsheet? | New Users to Excel | |||
how to increase the font size in a dropdown list? | Excel Worksheet Functions |