Bring the cell format along with the cell value from a reference c
 

I am trying to copy the cell value along with the format from a reference
cell. The cell being referenced has a formula for the value and conditional
formating to define the color.

A simple reference i.e. ='sheet1'!H3 will only copy the value.

How can I copy the formating?

i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell
to be red too.

Bring the cell format along with the cell value from a reference c
 

Formulas return values.........not formats.

Must be done through a seperate step by using the Paintbrush icon to also copy
the CF


Gord Dibben MS Excel MVP

On Fri, 20 Jan 2006 13:07:02 -0800, "Lorrie Horgen" <Lorrie
wrote:

I am trying to copy the cell value along with the format from a reference
cell. The cell being referenced has a formula for the value and conditional
formating to define the color.

A simple reference i.e. ='sheet1'!H3 will only copy the value.

How can I copy the formating?

i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell
to be red too.