Hi,
I suggest you put the codes into a range, then use a formula rule like
=MATCH($E2,range_with_codes,0)
applied to the entire range you want coloured. I've assumed that starts in row 2 but if not, adjust the 2 in the formula to match the first row of the data.
Bookmarks