How to link a cell format with another cell?

M

Merbman

New Member
Joined
Mar 3, 2002
Messages
4
I have not found this topic yet ! I would like to link a cell with another cell. Not only the value, but also the format. How can I link the format of a cell to another cell? The result will be a changed cell when I have changed the source cell. Thanx !

--------------------------------------------------------------------------------
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
You could copy the cell you've linked to then Paste Special- Formats onto your destination cell. But, unless it's a conditional format, then changes to the format of the linked cell aren't updated automatically to the destination cell. Sorry I can't be of more help :smile:.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
When removing links with copy and paste special some values appear in scientific notation or expanded decimal places.
Replies
7
Views
268
BYahr
B
A
  • Question Question
Changing row number dynamically in link to another file
Replies
1
Views
193
AlphaFrog
AlphaFrog
B
  • Question Question
link a VBA checkbox to a Cell to change value
Replies
6
Views
392
NoSparks
N
C
  • Solved
Excel formula not recognising cells with a General format
Replies
3
Views
179
6StringJazzer
6StringJazzer
A
  • Solved
Target.address and VLOOKUP with a range of cells
Replies
8
Views
315
RoryA
RoryA

Forum statistics

Threads
1,223,365
Messages
6,171,653
Members
452,415
Latest member
mansoorali

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top