Autofil color to a row from dropdown list choices

A

Alesia

I am trying to autofil certain colors to rows that have dropdown choices.
Each choice will be assigned a certain color.
 
G

Gord Dibben

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
 

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

Printing from Word my Inserted Pictures colors are dull and lack color 0
Changing row background from external program 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Need help modifying code 0
Dropdown with signatures 1
macOS Office365 Word 0
Outlook Shared Calendar not displaying color categories to all users. 0
Autofill Format 3

Top