| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change color or type size in an Excel TEXT function
I want to be able to change the color and font size of the TEXT function in
an Excel equation as follows: ="The following number is red "&text(a1,"##") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change color or type size in an Excel TEXT function
John P. wrote:
I want to be able to change the color and font size of the TEXT function in an Excel equation as follows: ="The following number is red "&text(a1,"##") Not sure what you want. Can you be a little more specific? Also, what version of Excel (2000, 2003, 2007)? Do you want the Text of the cell containing the statement '="The following number is red "&text(a1,"##")' to be RED or the cell A1 to be RED. Have you looked at Conditional Formatting? However, I don't think you can affect the font size with Conditional Formatting. -- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change color or type size in an Excel TEXT function
Formulas don't support this type of character by character formatting.
John P. wrote: I want to be able to change the color and font size of the TEXT function in an Excel equation as follows: ="The following number is red "&text(a1,"##") -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change color or type size in an Excel TEXT function
I want to be able to change the number returned by the TEXT function to be
[red] and the balance of the text in the cell to remain as formatted in the cell (black) "Chris Premo" wrote: John P. wrote: I want to be able to change the color and font size of the TEXT function in an Excel equation as follows: ="The following number is red "&text(a1,"##") Not sure what you want. Can you be a little more specific? Also, what version of Excel (2000, 2003, 2007)? Do you want the Text of the cell containing the statement '="The following number is red "&text(a1,"##")' to be RED or the cell A1 to be RED. Have you looked at Conditional Formatting? However, I don't think you can affect the font size with Conditional Formatting. -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the color/type of the borders I put on cells? | Excel Discussion (Misc queries) | |||
| Color Change Text by type of Entry | Excel Discussion (Misc queries) | |||
| Can an Excel logic function change the color of a cell or text? | Excel Worksheet Functions | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| Change Text-color depenting on SUM-function | Excel Worksheet Functions | |||
![John P.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
