I would like to somehow program a column of cells to allow users to pick one
of 4 background colors (red, blue, green, brown). Is there a way that I can
have like a drop down list with only these colors available?

You could use values in a range of cells and have them set in Conditional
Formatting?

Corey....
"MelanieZ" wrote in message
...
I would like to somehow program a column of cells to allow users to pick
one
of 4 background colors (red, blue, green, brown). Is there a way that I
can
have like a drop down list with only these colors available?

No Actually it will contain any value, the background colors are constant. I
can't tie a specific value to a color.

"Corey" wrote:

You could use values in a range of cells and have them set in Conditional
Formatting?

Corey....
"MelanieZ" wrote in message
...
I would like to somehow program a column of cells to allow users to pick
one
of 4 background colors (red, blue, green, brown). Is there a way that I
can
have like a drop down list with only these colors available?

i have a form that basically does that. if you want it, i can email it you and
then you can import it into your workbook.

--


Gary


"MelanieZ" wrote in message
...
I would like to somehow program a column of cells to allow users to pick one
of 4 background colors (red, blue, green, brown). Is there a way that I can
have like a drop down list with only these colors available?

That would be great if you would, I would greatly appreciate it. My email
address is

"Gary Keramidas" wrote:

i have a form that basically does that. if you want it, i can email it you and
then you can import it into your workbook.

--


Gary


"MelanieZ" wrote in message
...
I would like to somehow program a column of cells to allow users to pick one
of 4 background colors (red, blue, green, brown). Is there a way that I can
have like a drop down list with only these colors available?