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.