Cond. format text color based on another's text color

[manxman]

I want to copy text from A1 to C1, and if A1 text is red, then the copy
should be black(automatic), and vice versa. Can I do this in conditional
formatting, or do I need to go to VBA?

 

[Dave F]

VBA.

 

[manxman]

OK. Would you briefly tell me how? I am a newcomer to VBA, but willing to
learn. Thanks for the help.

 

[Dave F]

Ahh, that's the $64,000 question.

I'm not sure how, as I'm a relative newcomer to VBA as well, however, this
web site has a wealth of information about colored cells and VBA:
http://www.cpearson.com/excel/SortByColor.htm

Dave