Help with Conditional formatting in a cell range.

I have a sheet that our employees update with a two digit code (a solution code to a problem) I have a list of codes that flag for equipment codes (about 100 codes) to be entered into another system. What I would like to accomplish is to have the spreadsheet highlight the cell if one of those codes for equipment are used on the spreadsheet they use for updating. I have tried the conditional formating "equal to" function but it will not allow me to select a row of codes regardless if they are on another sheet or column on the same sheet.

If there a formula that I can use to accomplish what I am trying to do?

Hi and thank you for the speedy reply. Sorry I have been out of town for a week and just got back. I tried what you said but I am unable to get it to work.

I selected a2-a120 and named it DET and than followed your instruction for setting up the conditional formatting but I am unable to get it to work. I have attached my sheet with my attempt at it. Can you please let me know what I am doing wrong?

Like this?

Yes, What did I do wrong?

Your formula referenced cell A2 rather than $C2 which holds the criteria you're formatting. You'll also notice I converted your data range to a 'table' so that any time you add a new line of data, the table automatically extends and the CF is applied to each new row.

Hope that helps...