Colour references in formulas.

B

Big Rick

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.
 
S

swatsp0p

Big said:
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.
Click to expand...

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

shadestreet

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.
 
Top