Linking cell formats from one wrk sht to another

christal · May 3rd, 2002, 07:41 AM

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

Brian from Maui · May 3rd, 2002, 09:45 AM

Christal,

Have you tried Edit/Paste Special/Formats?

christal · May 3rd, 2002, 10:04 AM

How Obvious is that!! I am so embarrassed!!

Thanks for the tip!!

It worked!!

christal · May 6th, 2002, 06:47 AM

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!!

Thanks!

[ This Message was edited by: christal on 2002-05-06 05:49 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 07:41 AM	#1
christal New Member Join Date: Apr 2002 Posts: 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

May 3rd, 2002, 09:45 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Christal, Have you tried Edit/Paste Special/Formats?

May 3rd, 2002, 10:04 AM	#3
christal New Member Join Date: Apr 2002 Posts: 45	How Obvious is that!! I am so embarrassed!! Thanks for the tip!! It worked!!

May 6th, 2002, 06:47 AM	#4
christal New Member Join Date: Apr 2002 Posts: 45	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!! Thanks! [ This Message was edited by: christal on 2002-05-06 05:49 ]