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