Ooop Sorry there is an = too many in there.

Also - How to I get an Alias email Bernard? - (Sorry Newbie!)


ChemicalJasper wrote:
Bernard,

Thanks for the reply.

Forgive me but this seems to do the same thing as I have already got
but in a different way.

=LEFT("||..|",A1)&=LEFT("||..|",A2)&LEFT("||..|",A 3)

Are you saying there is no way to format colour within a formular?

Thanking you

Steve

Bernard Liengme wrote:
How about =LEFT("||||||||||||||||||||||||||||||",A1) where A1 has a numeric
value
---- until you buy Excel 2007 that has the feature you want.

You should have an alias email address when sending messages to newsgroups.
Otherwise, crawlers will find you and send spam.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ChemicalJasper"
ups.com...
I want to know if it is possible to format text within a formular?

Using the =REPT("I",cell) formular - ( from Juice
Analytics)
you can effectively draw a small bar chart in a sigle cell.

What I want to do is combine three cells to a single bar, but have each
cell value formatted as a different colour, within the single.

so formular currently is,

=(REPT("|",cell 1))&(REPT("|",cell 2))&(REPT("|",cell 2))

What I want to do is (but obviously the below does not work - is there
a format to do this?)

=([Red]REPT("|",cell 1))&([Blue]REPT("|",cell
2))&([Green]REPT("|",cell 2))