Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Font Characteristics Within a Formula
How do I change the font color and make it bold within a formula? I am trying to link two different cells with text in them to one cell and I would like to have the color and font weight changed for just one of the links. For example... A1=1 A2=2 I want B1 to show 1(black normal font), 2(red bold font) Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467599 |
#2
|
|||
|
|||
What you want is called Conditional Formatting. See Excel Help.
-- Gary''s Student "jdurrmsu" wrote: How do I change the font color and make it bold within a formula? I am trying to link two different cells with text in them to one cell and I would like to have the color and font weight changed for just one of the links. For example... A1=1 A2=2 I want B1 to show 1(black normal font), 2(red bold font) Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467599 |
#3
|
|||
|
|||
Formulas don't support that type of formatting--and neither do real numbers.
Only Text supports it. jdurrmsu wrote: How do I change the font color and make it bold within a formula? I am trying to link two different cells with text in them to one cell and I would like to have the color and font weight changed for just one of the links. For example... A1=1 A2=2 I want B1 to show 1(black normal font), 2(red bold font) Thanks. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=467599 -- Dave Peterson |
#4
|
|||
|
|||
Formulas can only return values, including text, but cannot change formatting
of those values. After returning the value with a formula you could copy and paste specialvalue then manually edit the result in the formula bar. Or you could use VBA to achieve the same result. Gord Dibben Excel MVP On Wed, 14 Sep 2005 13:59:28 -0500, jdurrmsu wrote: How do I change the font color and make it bold within a formula? I am trying to link two different cells with text in them to one cell and I would like to have the color and font weight changed for just one of the links. For example... A1=1 A2=2 I want B1 to show 1(black normal font), 2(red bold font) Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the Master Sheet Formula | Excel Discussion (Misc queries) | |||
mixed font styles in the output of a formula? | Excel Worksheet Functions | |||
Copying a formula and changing ONE value... | Excel Worksheet Functions | |||
Changing font size in a list box | Excel Discussion (Misc queries) | |||
Mixing Font Sizes In A Cell Formula | Excel Worksheet Functions |