Progress Bar

[PAL]

I have a spreadshet, multiple rows/columns. Essentially a list of metrics
with a description, how we gather info, who owns it etc...

I would like to be able to take a specific field and fill it with color but
as a gradient. Essentially to show progress. Is there a way to do this in a
field w/o VB? Does it have to be a separate chart etc....

Thanks.

 

[Tieske]

Excel 2007 does it out of the box. For older versions you need some tricks.
Using a graph is the best option in that case.

alternatively, use 1 row and 10 column and change the background of each
cell (using conditional formatting) depending on the progress. This would
give you a progress bar with a 10% increment.

 

[PAL]

Thanks. Can you provide an example of how the conditional formula would work?

 

[Bob Phillips]

Use it with a formula something like

=$A$1>COLUMN()

as A1 is incremented, another column lights up.