Colored Drop Down Box
 

I need a drop down that will shade the cell either Red or Green. The drop
down list only needs to show R or G. When you click R, it will make that
cell RED. I know a bit about data validation and lists. I don't know
anything about VLookups. If you have the answer, please make it VERY user
friendly.

Colored Drop Down Box
 

Apply conditional formatting to the cells. Have the drop down as r or g and
then set c/f to color fill and make text red or green when it sees r or g.
--
Russell Dawson
Excel Student


"Cindy" wrote:

I need a drop down that will shade the cell either Red or Green. The drop
down list only needs to show R or G. When you click R, it will make that
cell RED. I know a bit about data validation and lists. I don't know
anything about VLookups. If you have the answer, please make it VERY user
friendly.

Colored Drop Down Box
 

Anyway. Why cant you have the cell changing color based on an event in your
w/s. You appear to be deciding yourself when to turn it r or g and
presumably something has happened to make that decision. If you can explain
a little further then perhaps your w/s can be improved.
--
Russell Dawson
Excel Student


"Cindy" wrote:

I need a drop down that will shade the cell either Red or Green. The drop
down list only needs to show R or G. When you click R, it will make that
cell RED. I know a bit about data validation and lists. I don't know
anything about VLookups. If you have the answer, please make it VERY user
friendly.

Color Coded Drop Down Box
 

It is somewhat of a survey. The team reads the questions and then they must decide on either Red or Green. I got the boxes working fine, just from text and conditional formatting. I thought there was something more to it. Thanks for your response.



Russell Dawson wrote:

Anyway.
16-Feb-10

Anyway. Why cant you have the cell changing color based on an event in your
w/s. You appear to be deciding yourself when to turn it r or g and
presumably something has happened to make that decision. If you can explain
a little further then perhaps your w/s can be improved.
--
Russell Dawson
Excel Student


"Cindy" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Annotate Images from a database in a web page
http://www.eggheadcafe.com/tutorials...images-fr.aspx