condition formatting

[Puggwash]

can I condition format cells that are not joined together in a worksheet when I enter a figure.
Lets say I have 280 cells and cell 1 is D6 and it goes down to Cell 40 = D48. Cell 41 = G6 to Cell 80 = G48. Cell 81 = J6 down to Cell 120 = J48.

How do i condition the cells so the colour changes when I enter a figure to represent the amount of boxes I need?

 

[Puggwash]

now I have done this how do i do the following, each cell is = to 135 so the value in A1 (say 10,000) = 74 cells to colour and leave me the remainder. i have tried to apply but it does not work for me. Any help.

 

[Puggwash]

now I have done this how do i do the following, each cell is = to 135 so the value in A1 (say 10,000) = 74 cells to colour and leave me the remainder. i have tried to apply but it does not work for me. Any help.

 

[Puggwash]

now I have done this how do i do the following, each cell is = to 135 so the value in A1 (say 10,000) = 74 cells to colour and leave me the remainder. i have tried to apply but it does not work for me. Any help.

 

[Puggwash]

I have worked out how to format all the cells I have asked about but have an error.
As said befoe each cell = 135 so the total in A1 dictates the Qty of cells I need to colour. What happens if (lets say) A1 = 2000. this should be 14 cells coloured and leave me with the remainder of 110 but my cells colour 15 cells.
Do I need to rounddown or do something with them to get the right amount of cells.

 

[milesUK]

2000/135=14.8. Rounded gives 15 so that may explain that.
Why not set A1 to "=INT(B1/135)" and put 2000 in cell B1.