Stock Inventory vs orders sheet

[Kiwi2020]

Hello all,

I am hoping someone can help me. I am looking for a way to highlight any orders that are put in to a sheet that take the requirement over the current stock, But only highlight those orders not the ones there is enough stock for. So in the example below Alice's order of code 123 would need to highlight as there is not enough stock to fulfill this requirement.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Order Number[/TD]
[TD]Code 1[/TD]
[TD]Code 2[/TD]
[TD]Code 3[/TD]
[TD]Code 4[/TD]
[TD]Code 5[/TD]
[TD]Code 6[/TD]
[TD]Code 7[/TD]
[TD]Code 8[/TD]
[TD]Code 9[/TD]
[TD]Code 10[/TD]
[TD] [/TD]
[TD]Code[/TD]
[TD]Stock[/TD]
[/TR]
[TR]
[TD]Joe
[/TD]
[TD]1234[/TD]
[TD]123[/TD]
[TD]124[/TD]
[TD]125[/TD]
[TD]128[/TD]
[TD]134[/TD]
[TD]135[/TD]
[TD]136[/TD]
[TD]139[/TD]
[TD]140[/TD]
[TD]141[/TD]
[TD][/TD]
[TD]123[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]1235[/TD]
[TD]128[/TD]
[TD]125[/TD]
[TD]123[/TD]
[TD]134[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]124[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]2345[/TD]
[TD]125[/TD]
[TD]123[/TD]
[TD]134[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]125[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Alice[/TD]
[TD]3658[/TD]
[TD]123[/TD]
[TD]128[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]126[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

I hope this makes sense.

Many thanks in advance for any assistance.

 

[MickG]

You're very welcome