Excel Formula Help

Hello Everyone,

I want to create a simple project-like Excel workbook.

It would be setup in the following manner:

A1 = task
B1-L1 = empty cells denoting percent complete (each cell = 10%)
H1 = %Complete

What I want to do is put in H2 a value – 10-100 (in increments of 10) and the appropriate number of cells will be shaded.

So, it would look something like this:

A B C D E F G H I J K L
1 task1 * * * * * * * * * * 100
2 task2 * * * * * 50

I’m not sure if this can be completed with a formula or a macro.

I know that there are some freebees out there that will do this, but I want something simple to help in everyday ‘mini’ projects at the office.

Any thoughts or ideas?

Thanks in advance and much appreciated.