Automatically highlight cell when data entered does not match with data in other column

Hello

I am not a programmer so I apologize if my title seems confusing. This is what I meant: All the vehicle no. are the same. Cells E4 and E6 will auto highlight as the S/N is incorrect, with respect to the sticker location. Cell E5 will not auto highlight as the S/N is correct, with respect to the sticker location. 

Then for E4, if the user re-entered '3846', the cell would turn to 'no fill'/clear the cell. For E6, it's not applicable for this example as there are no prior records.

Screen Shot 2018-09-25 at 11.52.00 AM.png

Hope that someone could help me out. The VBA code that I hoped for is that the formula is applicable for all rows (in reality I have 700+ rows), but the columns are fixed to these 3 columns (E, F & G). Thank you so much!