hi, im wanting to find out how to work out a program to automatically colour my grids.
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.
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.