how to copy cell formatting in formula

  • Thread starter Thread starter JBW
  • Start date Start date
J

JBW

This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please
 
This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please
Click to expand...

Hi

Copy your cell, then in the destination cell right click, choose Paste-
Special,
select "Values" if that's waht you want or "Formulas" if you want to
retain the formula. No formatting will come across.

Regards,
Justin
 
This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please
Click to expand...

Hi

Copy your cell, then in the destination cell right click, choose Paste-
Special,
select "Values" if that's waht you want or "Formulas" if you want to
retain the formula. No formatting will come across.

Regards,
Justin
 
Justin Case said:
Hi

Copy your cell, then in the destination cell right click, choose Paste-
Special,
select "Values" if that's waht you want or "Formulas" if you want to
retain the formula. No formatting will come across.

Regards,
Justin
Click to expand...
Not strictly true - if you have XL2007 then paste special > All using source
theme - will copy format as well!
Another alternative:
Link two worksheets > Alt click on the worksheet tabs, then whatever you
type or format on one sheet will be repeated in the same cell/group of cells
in the other sheet. Don't forget to unlink after you have finished.
 
Justin Case said:
Hi

Copy your cell, then in the destination cell right click, choose Paste-
Special,
select "Values" if that's waht you want or "Formulas" if you want to
retain the formula. No formatting will come across.

Regards,
Justin
Click to expand...
Not strictly true - if you have XL2007 then paste special > All using source
theme - will copy format as well!
Another alternative:
Link two worksheets > Alt click on the worksheet tabs, then whatever you
type or format on one sheet will be repeated in the same cell/group of cells
in the other sheet. Don't forget to unlink after you have finished.
 
guys I need the format to copy over as part of a formula.

eg. worksheet 1 cell A1 text says 'bob' cell is filled red
worksheet 2 cell A1 has formula =worksheet1!A1

So I would like the word Bob to pop up in worksheet 2 cell A1 and for the
cell to be filled red, as per the same cell it references in worksheet 1
 
guys I need the format to copy over as part of a formula.

eg. worksheet 1 cell A1 text says 'bob' cell is filled red
worksheet 2 cell A1 has formula =worksheet1!A1

So I would like the word Bob to pop up in worksheet 2 cell A1 and for the
cell to be filled red, as per the same cell it references in worksheet 1
 
This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please
Click to expand...

It is not possible to copy formats using worksheet functions.

Functions only return values.

If the manual methods described are not satisfactory, you will need to either
pre-format the cells using conditional formatting, if that is appropriate, or
use a VBA Macro.
--ron
 
This is going to be easy peasy I know, but it's got me stumped.

I need to copy a cells contents and format (not conditional) into a
frontsheet.

Using simple =example!C1 the cell contents come over but not the colouring

Help please
Click to expand...

It is not possible to copy formats using worksheet functions.

Functions only return values.

If the manual methods described are not satisfactory, you will need to either
pre-format the cells using conditional formatting, if that is appropriate, or
use a VBA Macro.
--ron
 
Back
Top