Copy cell and the font color

  • Thread starter Thread starter Falcon248
  • Start date Start date
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.
 
A formula can only return a value to a cell, no formats and such.

HTH

Regards,
Howard
 
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.
 
Back
Top