I have a worksheet that has 280 boxes (1-280) which we normally colour in when we complete the required order made. This is done in stages of 10's.

I have an 'Estimate' box (P64) that shows a figure (say 2000) and a 'Open Stock' box (B43) that shows a figure (say 200). Now my quantity I require is 1800 (Estimate minus Open Stock).

How do I work the program to work out what amount of boxes I need for the quantity required so it colours them automatically and we know where to go to without working it out.

Hope this makes sense.