LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
cerah
 
Posts: n/a
Default Creating links to cells with no content, but that have formatting

I am trying to link a group of cells that have no content, but that all have
a blue pattern background into a new file. When I link the cells, zero comes
up because there is no content. I know there is a way to fix that, but is
there a way to link to the formatting? This way if i change it from blue to
red on the source page, my new file will show that change?

I tried copypaste specialpaste link, then paste specialformats, but it
only copies the format, it doesn't link it, so it does not reflect changes in
the original documents formats when I make them.

Any ideas?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move merged cells with conditional formatting? SpikeUK Excel Worksheet Functions 11 December 8th 05 05:04 PM
Formatting on unprotected cells MargaretAnnM Excel Discussion (Misc queries) 1 October 21st 05 12:22 AM
Conditional formatting...cont. from 9/25 Guenzak Excel Discussion (Misc queries) 4 September 26th 05 10:55 PM
Formatting cells is not retained when saved as csv file sheba0907 Excel Worksheet Functions 0 September 7th 05 05:39 PM
Conditional formatting on cells with a VLOOKUP formula in them JenniM Excel Discussion (Misc queries) 4 April 1st 05 06:45 PM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"