Hello wonderful experts! Apologies that my header was long - I'm trying to accurately describe my problem.
I'd like for any cell to turn orange upon entry (Sheet1, A2:A17) if the data entered there does not equal a project on the list shown on Sheet2.
For example, if they enter just the number "5" in A2 on Sheet1, it would turn orange because that isn't an offered project code on Sheet2. If they entered "402Plan" it would stay white, because it IS on the list on Sheet2. I thought at one point I had it figured correctly but it may have only worked for the same corresponding cell, and I need it to look at the whole range on Sheet2. They also have the option of leaving it blank, with no project Code on Sheet1. I hope that makes sense. I've tried a lot of searching but can't seem to find a clear solution for this assumed conditional formatting. Thank you in advance!
I attached a much smaller example of what I referenced above.