Drop Down List Conditional Formating

  • Thread starter Thread starter Sdaisy1
  • Start date Start date
S

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)
 
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.
 
Back
Top