No you are correct, the conditional formatting was with regards to the first
person answering you saying that
you cannot copy conditional formatting. There is no way using the format
painter and copy a format where different characters have different
colours, in fact there is no way of copying that period. Same in Word

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"dgc49" wrote in message
...
I am not using conditional formating so this doesn't apply to me in this
situation. The problem appears to be with the use of mixed colors with in
a
text string in the cell. Copying the contents of the cell isn't a problem,
but copying just the format seems to be a problem for mixed font colors.
Single font colors copy just fine as do all other format information. If
you
can duplicate my efforts and come up with different results, please let me
know.

dgc49

"Peo Sjoblom" wrote:

Yes they can, if you have formula is =A23
if you use the format painter to copy that to A3 the formula will change
to
=A33 so the conditional formatting will carry over

However you cannot copy partial cell formatting either with the painter
or
copy paste special format


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"C01d" wrote in
message
...

The format painter should be able to copy the text color. However, you
might want to check if the cell text was colored using conditional
formatting. Conditional formats cannot be copied in this manner.


--
C01d
------------------------------------------------------------------------
C01d's Profile:
http://www.excelforum.com/member.php...o&userid=34422
View this thread:
http://www.excelforum.com/showthread...hreadid=548180