Hi,

I have seen the data bar conditional formatting in Excel 2007 which I must
say is brilliant!! The only problem I have is that I can't seem to get it to
use a solid bar... as opposed to the gradient fill it uses. Also, even at
100% it never seems to go all the way to the very end of the cell. If anyone
has found a way to get around this I'd be truly grateful.

Thanks.

And at 0% it never goes all the way to the left. So it's bright, but not
brilliant.

These data bars are intended to use the gradient, I guess so they don't
interfere visually too much with the right-justified number in the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PG Oriel" <(E-Mail Removed)> wrote in message
news:CF64D3DA-F636-4679-91F3-(E-Mail Removed)...
> Hi,
>
> I have seen the data bar conditional formatting in Excel 2007 which I must
> say is brilliant!! The only problem I have is that I can't seem to get it
> to
> use a solid bar... as opposed to the gradient fill it uses. Also, even at
> 100% it never seems to go all the way to the very end of the cell. If
> anyone
> has found a way to get around this I'd be truly grateful.
>
> Thanks.