The color of the text is completely independent of its value. The same
number is red in some cells, and black in others.

"Ian" wrote:

It should be possible with VBA code, but an easier option might be
conditional formatting. Is there anything specific about the value in A1
which determines the colour? Could you use this property to set a formatting
condition (eg is it red for negative numbers, black for positive. Is it
anything to do with the content eg part of the text, length of the string
etc)?

--
Ian
--
"manxman" wrote in message
...
I want to copy text from cell A1 to cell C1, and if the text in A1 is red,
make C1 black, and vice-versa. There is no formula in A1.