Hi,
You can not partial shade a single cell. What you can do is use multiple
cells with some conditional formatting.
Have a look at a recent post of my on another forum.
http://www.excelforum.com/showthread...ht=conditional
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RBear3" wrote in message
...
I am creating a spreadsheet where I will have a long list of projects. One
column represents the completion percentage for the project. I'd like to
display this as a progress bar. If the project is 50% complete, I want the
left half of the cell to be colored in. If it is 75% complete, I want the
left 3/4 of the field to be filled in, etc.
I don't mind doing this manually if there is a way to do so, but I figured
there might be some type of control that can do this.
I have seen reports built in accounting packages and "dashboard" or
"metric tracking" applications that do similar visual representations for
individual line items on reports.
Thanks for your suggestions!!
--
RBear3
.