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
--
Brevity is the soul of wit.


"manxman" wrote:

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

"Dave F" wrote:

VBA.
--
Brevity is the soul of wit.


"manxman" wrote:

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?