Colored Drop Down Box

C

Cindy

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.
 

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

Drop down lists in seperate columns 5
Drop down list control value in vba 2
How to filter rows data based on background color of individual cells 3
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Print Macro w/drop down list 1
Filtered drop down list 2
Drop down in Graph (excel 2003) 2
Drop Down Selection Assistance 2

Top