format painter wont copy mixed font colors from one cell to next
dgc49
blk_txt/blu_txt). I can't get format painter or copy & paste spacial to copy
this format to another cell. It just copies the text in blk_txt only. Is
there a way around this or is by default the way Excel works.
C01d
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?action=getinfo&userid=34422
View this thread: http://www.excelforum.com/showthread.php?threadid=548180
Peo Sjoblom
if you use the format painter to copy that to A3 the formula will change to
=A3>3 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" <C01d.28ux5m_1...@excelforum-nospam.com> wrote in message
news:C01d.28ux5m_1...@excelforum-nospam.com...
dgc49
into a cell with the 1 as black, 2 as red, 3 as green, and 4 as blue in color
this is what I get. I can copy the contents of this cell exactly as is to
another cell intact. If I change the font colors of that 2nd cell back to
black, then use Format Painter to copy the format of the 1st cell to the 2nd
cell, every thing is copied over except the font colors. I discovered this
when making an information sheet stated lengths in inches and centimeters and
I used black for the numbers in inches and blue for the nunbers in
centimeters to simplify reading the sheet. I ran into the problem of copying
the format from one cell to another with the colors and had to do this
manually. I suspect that this is a bug in Excel, but if some one can show me
that this can be down, please do.
dgc49
Painter function only copies the font color of the first character of the
text string. So if the first character is black, then the entire copied
string will be black. If the first charater is red, the entire copied string
will be red. This happens regardless of the other colors used in the string.
It appears that the only way that mixed colors in a text string can be copied
over is if the entire string contents are copied are copied. This appears to
be a bug in Excel or something that none of the programmers ever thought of.
As an Autocad user, I use Autocads Format Painter all the time and it works
the way I expect. I would have though that Microsoft would have put in that
same functionality since they use the same name and are supposed to be
compatible with Autocads formats. Hmmmmm......
dgc49
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
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" <dg...@discussions.microsoft.com> wrote in message
news:DA01348C-E026-4755...@microsoft.com...