Drop Down List Conditional Formating

[Sdaisy1]

I need to know how to have an item highlighted on a list once it has been
selected using the drop down menu? (i.e. so I know not to pick that item
again, I want to have it highlighted in red)

 

[Shane Devenshire]

Please explain - there is no drop down list in conditional formatting that
the user picks because conditional formatting is automatic. If you are using
a list in the spreadsheet it depends on where and what type of list you are
refering to, list can be:
1. Pivot Table field list
2. AutoFilter dropdown lists
3. Data Validation lists
4. User Form Lists
5. ActiveX control lists
6. Autocomplete lists

I don't think you can color code any of them, however, maybe there is a vba
solution depending on which you are refering to.

You can set a data validation or write vba code to block the picking of the
same item twice from at least some of these lists.

 

[T. Valko]

You can't color code the items in the data validation list itself.

See this:

http://contextures.com/xlDataVal03.html