software

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.

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

Must be done through a seperate step by using the Paintbrush icon to also copy
the CFGord Dibben MS Excel MVP

On Fri, 20 Jan 2006 13:07:02 -0800, quot;Lorrie Horgenquot; lt;Lorrie
gt; wrote:

gt;I am trying to copy the cell value along with the format from a reference
gt;cell. The cell being referenced has a formula for the value and conditional
gt;formating to define the color.
gt;
gt;A simple reference i.e. ='sheet1'!H3 will only copy the value.
gt;
gt;How can I copy the formating?
gt;
gt;i.e. the H3 cell in sheet1 has fill color = red. I want the reference cell
gt;to be red too.