Question

Locked

Excel Formula Help

By tang0312 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums