Formatting text in a formular

[ChemicalJasper]

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))

 

[Bernard Liengme]

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

 

[ChemicalJasper]

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("||..|",A3)

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

Thanking you

Steve

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"

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))

 

[ChemicalJasper]

Ooop Sorry there is an = too many in there.

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

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("||..|",A3)

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

Thanking you

Steve

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"

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))

 

[Dave Peterson]

You can't do character by character formatting in formulas.

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("||..|",A3)

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

Thanking you

Steve

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"

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))

 

[Bernard Liengme]

A formula cannot change a format. But you can use Conditional formatting.
Example: if A1 > 10 then you could have the cell with my LEFT formula
display the bars in red.

ALIAS: I use Outlook Express. On the menu bar use Tools|Accounts; open the
News tab and select your news service; click Properties; in the email
address box type an alias (I just add come capital letters to my real email
address) Other news clients let you do similar things.

You seem to be a chemist like me. Do you know about the formatting add-in
for Word, Excel and PowerPoint found at
http://spectrum.troy.edu/~cking/ChemFormat/index.html If is just great.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Ooop Sorry there is an = too many in there.

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

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("||..|",A3)

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

Thanking you

Steve

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"
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))