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.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums