Use Conditional Formatting or VBA to higlight cells based on the demand covered by type of stock

[FariAb]

Hi everyone! I have a situation, I have three types of Stock: regular stock, stock that is on its way and ordered stock. I also have a certain demand for each material each day. So I'd like to see how many days the demand is covered by each kind of stock. When it is working properly it should look something like this:

I'm not sure if it could be made through conditional formatting or if a VBA code would be needed, if the latter is required I was thinking to make the macro sum values until the amount of the first stock is reached and then color the cells or subtract each daily demand from the total stock. If someone could help me with that it's be amazing!
Thanks beforehand and have a great day!

 

[bebo021999]

1) Is it all the possibilies?
How about :
E2=4, F2=6 change to E2=6 and F2=10?
2) what do the color mean? pls explain why that color in each cell?