Data Validation List

M

m.w.c

In previous versions of Excel (i.e. 2003) you could create validation lists,
format each cell with a different color (e.g. red, green , and yellow) and
once the list was advertised in the desired cell and the value selected from
the drop down list that formatting was carried over to the cell of the
selected value. In 2007 it doesn't seem to work. Can anybody recommend what
I need to do to get this working?
 
G

Gord Dibben

None of what you describe for 2003 can be done without conditional
formatting or VBA code.

You can do the same in 2007.

Which cell(s) is/are to get the color?

What does "advertised" mean to you?

Can you show us in more detail what you want?

Use cell references to make it more clear, please.


Gord Dibben MS 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

Drop down list control value in vba 2
Extension of Dependent Pulldown Lists 2
Data Validation Error 1
Colored Drop Down Box 0
Data validation list using filtered range 3
2007 conditional formatting not playing ball 5
Data Validation Formulas 2
data - validation - list question 2

Top