Create box with number entered

[silverskye787]

In B20 is a cell to enter any number. example if i enter 3, it will create the 3 following boxes as shown in the above picture.

i need to know how do it create the 3 boxes automatically

thanks =)

 

[daniels012]

Well, I do this very thing by using conditional formatting. I highlight the first square area and go to Format> ConditionalFormatting> then formula Is and then =$B$20>0 then change the formatting for each cell.
The next set of cells you can have as the formula =$B$20>1

Hope this helps!
Michael