Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
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" wrote in message 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)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
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)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
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)) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
You can't do character by character formatting in formulas.
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)) -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting text in a formular
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 "ChemicalJasper" wrote in message ps.com... 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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting with text | Excel Discussion (Misc queries) | |||
Linked text formatting | Excel Discussion (Misc queries) | |||
Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
grayscale conditional formatting of text | Excel Discussion (Misc queries) | |||
Text Formatting | New Users to Excel |