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.