VBA to change cell interior colour rather than using conditional formatting

[Excellover123]

Hello Massage board
I have got a sheet that shows what delivery quantities I'm expecting. If the cell shows 0 then nothing is required, however, I'm wanting to colour the cell interior a different colour based on what supplier the goods are coming from.
The cells i want to colour are in D5:X5 on a sheet called Egg#. I would like it to check the part code in A3 & the delivery date's are in D2:X2
The delivery data is on a sheet called Exp Receipts. The Lookup key (Part code concatenated with the date) is in column H & the supply code is in column B.
I was thinking something like if the cell is >0 then a Xlookup to get the supplier code & changed the colour based on that?
Any help would be great.
Thanks in advance
Gary

 

[Herakles]

Do you potentially want a different colour for each supplier?

I wonder why each delivery is not on a different row.

 

[Excellover123]

Do you potentially want a different colour for each supplier?

I wonder why each delivery is not on a different row.

Hi Herakles, yes I was hope to. There's 6 suppliers altogether. I'm open to what colours can be used.
Here how the sheet looks

Regards, Gary

 

[Herakles]

You will need to store the colours somewhere.

One way to do this is to set the Fill colour of the cell on the supplier sheet that has the supplier code in it.

Can you post some data using XL2BB?