Excellover123
New Member
- Joined
- Jul 13, 2018
- Messages
- 37
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
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