Formula for searching data based on dates.

Hi,
I am trying to conditional format data for raw meat depending on whether it’s out of date (red), about to go out of date (amber) or has plenty of life left (green). I have it somewhat working when just 1 item of raw meat being used for 1 finished good product, highlighting only the amount of meat amount required, starting from the oldest date.
I am now trying to get a data table setup which splits up the total amount required for a particular product if there is more than 1 raw meat available for use and choose the amounts based on the meat life date, oldest date first.

The attached report shows the current layout I have, from columns A-Q. What I need help in is:
a) Someone to correct the CF formula I already have, as its fine apart from its highlighting column k, amber when it should be green.
b) Need help in setting the table shown in columns S-W.

Thanks