When using ="cell" copy cell value and cell format

J

Jim

Hi

When using simple ="cell reference" (eg =c2) Excel should copy the cell
value AND the cell format.

Is this possible?

Thanks
 
J

Jim

Ok, thanks. I thought it might be so easy I was being stupid. good to know
i'm not! :)

Any smart workarounds that you can think of?


--
Best Regards
Jim


T. Valko said:
Is this possible?
Click to expand...

Unfortunately, no. A formula returns only the value.
Click to expand...
 
T

T. Valko

Not really. Maybe conditional formatting but that's very limited to the
types of formatting available and would not be dynamic if you change the
formatting of the source cell.

--
Biff
Microsoft Excel MVP


Jim said:
Ok, thanks. I thought it might be so easy I was being stupid. good to
know
i'm not! :)

Any smart workarounds that you can think of?
Click to expand...
 
R

RagDyer

Depends on exactly what you're looking to accomplish.

As an example, say you want to link the range C2 to C10 to the range of AK10
to AK18.

In AK10 enter
=C2
And drag down to copy to AK18.

While the cells are *still* selected,
Hold <Ctrl> and hit < [ >.

This navigates (jumps) the selection to the source cells.
While the cells are *still* selected,
Click on the "Format Painter" icon (yellow paint brush) on the tool bar,
then
Hold <Ctrl> and hit < ] >.

This returns the selection to the destination cells (AK10:AK18).

Now, simply click in AK10.

This will *copy* the format of the source cells to the destination cells.
It does *not* make the format a part of the link!

If you changed the source format, the destination format would *not* change
without a new copy procedure.

Don't know if this helps or not?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Jim said:
Ok, thanks. I thought it might be so easy I was being stupid. good to
know
i'm not! :)

Any smart workarounds that you can think of?
Click to expand...
 
Top