Excel Alarm/Alert Code

[test1986]

Hi all,

I'm completely new to this forum so sorry if my comments dont make sense.

Ok i have the sheet which is attached. I want a piece of code to set up an alarm to tell me when there is a differentiation in some of the codes.

So i want it to look down column A which will look at the code and see if there is any other cells with this same code in column A. If there is i then want it to check the cell next to it in column B and see if there is a differentiation witht the prices. So if cell 56 has a code of 566.876 in column A and so does cell 108, but they both have different numbers in column B then i want an alarm to pop up and let me know or highlight the cells.

Hope this makes sense. Please let me know if it doesnt.

Cheers