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