I have a column (G) that has a bunch of part numbers (alpha numeric) I have
2 lists and would like the cell that matches any part number in Column A to
turn green and any part number that matches column B to turn orange, and the
third is any cell that doesnt meet any to turn RED.

Any suggestions

Thanks in advance
--
Nelson