Use Conditional Formatting to Shade Several Cells Based on Value of One Cell

[greenie256]

Project1.jpg

Hi,

I have set up a simple spreadsheet which shows me how many staff I have on at any particular time. I require to shade boxes so I can see how many staff there are so for example if I have 2 staff on, 2 boxes in the column should be shaded. I have been trying to do conditional formatting for this but the only way I can get it working is to format each cell indiviually which is extremely time consuming. Is there a way to paste the conditional format but amend it automatically.

Not sure I have explained this very well so have attached an image of the spreadsheet. The value in row 2 is the number that gets changed and hopefully the shaded cells in the colums will correspond with that number.

Thanks