Linking cell formats from one wrk sht to another

christal

New Member
Joined
Apr 7, 2002
Messages
45
I have tried linking the format of one worksheet to another, by using the Format, stlye function, and it will not work. Does anyone have a clue how to do this? I linked the data, and I also want to link the format of the cells (let's say the color of the cell). It is not conditionally formatting.

Any help would be greatly appreciated

Thanks
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Well... I guess it may have been obvious, but it doesn't work. So... let me recap my problem:

I am trying to link two spreadsheets together...., one spreadsheet that I input information into one, and the other that is updated automatically. The data gets updated, but the format of the cell doesn't, ie. color, etc.

I did cut and paste special: didn't work

I did Refresh All: didn't work

I opened both files and save them both: didn't work

I am lost! Anyone have any ideas??

Frustrated!! :confused:

Thanks!
This message was edited by christal on 2002-05-06 05:49
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

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