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.

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" wrote in message
...
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.

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

"Tieske" wrote:

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" wrote in message
...
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.

Use it with a formula something like

=$A$1COLUMN()

as A1 is incremented, another column lights up.

--
__________________________________
HTH

Bob

"PAL" wrote in message
...
Thanks. Can you provide an example of how the conditional formula would
work?

"Tieske" wrote:

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" wrote in message
...
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.