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.