Compare cell value to fixed array value

[detweiler]

Hope my ask actually makes sense...

I would like to have a macro that would compare the values in a column, let's say column J, to a fixed list or an array written in the macro, and then highlight the cell or change the text color of the value that doesn't match what's in the list?

Any suggestions on how to set this up are appreciated.

 

[detweiler]

Definitely know what I don't know looking at this. It's definitely an art form. I'm not exactly sure what else to say except thank you.