I have a workbook with 2 sheets. On sheet (1) is the
results of a macro. On sheet(2) is a set of valid values.

I would like to add an edit that compares the results in
Sheet(1) Col A with the valid values on sheet (2).

I was probably going to create a range for the valid
values but I'm looking for a easy way to cycle through
results in Col A sheet (1). I also want to highlight any
invalid value in Col A.

I appreciate any suggestions on how to accomplish this.
Thanks for the help