copy cell and formating

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I am copying information from on sheet to another in the same workbook. Is
there a way to copy the entire format of the cell automatically?

Page 1
A B C
1
2 3<~~ number is red and bolded
3

Page 2
A B C
1
2 +page1!B2 <~~gives me a black non bolded 3
3

I want page to to have a red bolded 3. Is there a way? Any help would be
nice thank you .......

Eric
 
so what is the difference between linking and copying. What would this look
like in a formula? I am currently using the +cell location.

Eric
 
Back
Top