4 digit code for similar product, new product unique code

Well, I think I may have done it!
You'll have to test it with your real data (I presume this is not really about fruits of various colours), but it seems to work.

Three helper columns (A:C) that can be hidden and the rest I shall let you work out.

The Product Code only has 64,000 entries at the moment, but it's easily extended to whatever you need. I had to restrict the file size, hence not the full 99,999 you asked for earlier in the thread.

The colour code will go up to 99 at present but again, can be extended if need be.

Let me know if it works.

S.