Wanting to clear dependent drops downs with 4 linked and highlight if they don't match

So I have 4 linked dependent drop downs in columns across a few hundred rows of data.

Drop 1 --> Selections for drop 2
Drop 2 --> Selections for drop 3
Drop 3 --> Selections for drop 4

I am looking to have the clear happen no matter what the parent is (drop 1, drop 2, drop3). I understand how to do one, but would like it to do

I would also like to have the selection highlight if it doesn't match the parent.

So if Drop 1 has as choices:
cat, house, food

And drop 2 has as choices:
tabby, manx, tiger
apartment, flat, castle
steak, rice, pickle

I would like to highlight apartment if the drop 1 choice is food or cat.

Thanks for any help!

Yup, I am assuming this will have to be done with VBA. I am just unsure how to make that happen with VBA.