Autofil color to a row from dropdown list choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to autofil certain colors to rows that have dropdown choices.
Each choice will be assigned a certain color.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
Autofill Format 3
Selection.AutoFill Destination:=Range 0
Autofill cell references with a pattern of every 110 rows 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Forms - dropdown - different font colors for each choice 1
Help with Date Function 3
VBA to autofill from relative location 2

Back
Top