Copy cell and the font color

F

Falcon248

Is there a way to use a formula to copy a cell (text) and it's font color? I
tried the = cell # and it does not bring the font color along.
 
L

L. Howard Kittle

A formula can only return a value to a cell, no formats and such.

HTH

Regards,
Howard
 
T

trip_to_tokyo

When copying keep the destination Workbook open at the same time as the
source Workbook and you should find that the font colour will copy across as
well.

Please hit yes if my comments have helped.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
how to get the content in bigger font and in color when points 0
Match table shading (color) to Visio color/Transparency 1
How can i set header background color with add-in developed within JavaScript? 0
Designate font as italic of another 0
When trying to make next word into bold font, it boldens the word before. 0
How does one change the font name with VBA? 0
Font is changing when editing a cell 0

Top