VBA Loop through column range and Offset the output

[Giggs1991]

Hi All,

I have the following data in column A of a worksheet starting from cell A1:

Column A Column B
====== ============
xxx
ABC
xxx
123
4567
876

I am looking for VBA code that will colour the cell in column B in yellow if the cell to the left in column A contains "xxx" or "XXX". It should also mention " over allocated" in column B if the cell to the left in column A has a value greater than 1000.

I have attached the expected output

 

[Peter_SSs]

Is it possible that more than 1 cell in column A is entered/deleted/changed/pasted at the same time?