Please can you tell me how to put colour references into a formula.
e.g
If
A1=Fred and B1=Smith
then
C1= Fred Smith.
("Fred" in red text, "Smith" in green text)

Thanking you in anticipation.
--
Big Rick

Big Rick Wrote:
Please can you tell me how to put colour references into a formula.
e.g
If
A1=Fred and B1=Smith
then
C1= Fred Smith.
("Fred" in red text, "Smith" in green text)

Thanking you in anticipation.
--
Big Rick

This cannot be done by a *formula* as you ask. This would take VBA
coding to accomplish (via a macro). Is this what you want to do?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473528

I am not clear on what your goal is, but have you tried conditional
formatting? (under "Data").

You can add up to three conditions for a cell, the conditions are
logical tests that can change the color depending on the contents of
the cell. It is limited, but it may be the solution if you want to
avoid creating a macro.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=473528

My understanding is the OP wants to have TWO colors of fonts within ONE
cell via a formula. Excel does not allow for this. Check out this
thread for more details...

http://www.excelforum.com/showthread...nt+colors+cell


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473528

Many thanks to you anyway.
I thought it was a lohg shot.
--
Big Rick


"shadestreet" wrote:


I am not clear on what your goal is, but have you tried conditional
formatting? (under "Data").

You can add up to three conditions for a cell, the conditions are
logical tests that can change the color depending on the contents of
the cell. It is limited, but it may be the solution if you want to
avoid creating a macro.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=473528