kadrleyn
Member
![77705 77705](https://chandoo.org/forum/data/attachments/77/77797-1db4abaa8a4522b1814bb9a396612daf.jpg)
In our template, the data in the selected column is filtered according to the selected value from the drop-down list on the userform (drop down lists are populated with unique and the sorted ascending values when userform is loaded). The text color of the cells in the filtered column is changed as blue.
Source