Conditional Format using Name Manager or List of Words

[SMT4494]

Hi,

I wanted to know if it is possible to create a conditional Format using a name manager or just a certain list of words.
I would like it to turn red whenever anyone inputs any word other than the words in data validation drop down box.


The Words in my data validation drop down box are in a name manager called "Category".


Please let me know if this is even possible.

[SMT4494]

This is a photo of the excel column


Picture1.jpg