Data Bars in Excel 2007
 

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.

Data Bars in Excel 2007
 

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