VBA to equal two criteria, then insert last row and colour cell

[kitsa]

Hi I'm trying to create a code to look up two different criteria in different column & cell and then if True, to insert last row and colour previous cell, as pic attached.
e.g. if Column A:A = "V & Cell (E2) = Column B:B, then insert last row and colour Cell in column B:B if = Cell (E2)

 

[kevin9999]

You would have a better chance of getting help if you responded when volunteers offered you suggestions.
VBA change cell colour

 

[kitsa]

You would have a better chance of getting help if you responded when volunteers offered you suggestions.
VBA change cell colour

sorry Kevin, but if I can get this issue sorted then maybe I can fix the other one.