Maybe you could just use a hyphen, or underscore, instead of the Char(12)
symbol and format it for BOLD-RED.........

Vaya con Dios,
Chuck, CABGx3



"Andreww" wrote:

Thanks but I probably didn't explain this too well...

While analysing data I frequently output "group by"'s or frequency
counts - eg age band and count in each band.

Copy this (from sql environment) into xl. Now I want to show column
%'s to see which age bands are important to my analysis.

Then so that I can graphically see which bands are important I put a
formula to the right of the col %'d which says =rept(char(12),b2) which
when copied down gives me a simple bar chart. Just to make it look a
bit better, rather than have a series of blocks I'd like more like a
line/bar. If I coloured the character in there to be of the right size
and colour, I think that would give me what I want.

If I just have the one profile, then yes I could do conditional formats
(though I'm not sure it would work as I want) or I could poss use some
VB. Using VB in an XLS which then goes to someone else is isn't
particulary PC savvy always causes problems.

But... all I want is something in the formula to say
=rept(format(char(12),"redbox"),b2) or something so that I can simply
use as a generic across all my profiles. I know format() doesn't exist.

Does this make it any clearer... or have I really muddied it up now!?

Thanks

Andrew