I have had help and thanks for the answers to my previuos questions but can soemone help me with this final part.
Ihave conditon formatted my cells, 280 in total so that when i place a figure in A1 the cells change colour to that total.
Now here is the hard part, each cell = 135 so if in A1 the figure is 2000 this should colour 14 cells and then leave me with 110 BUT in condition formatting it colours 15 cells!!!
How do I add a formula so that it only colours the full cells that add to 135, if you can understand the question.
Ihave conditon formatted my cells, 280 in total so that when i place a figure in A1 the cells change colour to that total.
Now here is the hard part, each cell = 135 so if in A1 the figure is 2000 this should colour 14 cells and then leave me with 110 BUT in condition formatting it colours 15 cells!!!
How do I add a formula so that it only colours the full cells that add to 135, if you can understand the question.