Data Validation

[Ramesh Chinnarasu]

Hello,

Need to add cell formats/patterns along with the cell value in data validation.

for ex: In the drop down list itself I would like to see the colors of the original list.

[sglife]

If the data in list is less than 3 , then you can use conditional formatting. Otherwise, you need VBA