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!
Bookmarks