|
Hi welcome to the board. If you change the formatting after you have created the link, the linked cell's formatting will not update. There might be a VBA solution though you would need to keep a close eye on cell addresses and/or use named cells and named ranges to maintain the integrity of the formatting. A workaround would be to use Conditional Formatting to change the formatting in both the original and the linked cells. If, for example you want a cell to change colour because its value exceeds a certain number that is easy to do. Simply apply the same CF to both cells. If you want to change colours for some other reason you could use a spare cell on the first sheet to contain the relevant criterion. Thus if your spare cell is Z1, name it (this is essential because you are using different sheets). Let's call it TestCell. Use Formula Is and the conditional format would be =TestCell=1 format as blue, =TestCell=2 format as green, =TestCell=3 format as red. Use the Format Painter to copy the formatting quickly to the linked cell. To change the formatting type 1, 2 or 3 in Z1.
You are limited to three formats but this may help.
Has anyone found a resolution to this problem?
hi
i've just joined this forum & found a lot of the posts very helpful. not sure if my problem is similar to above. i'm currently working in excel 2003. objective is once i change the contents & cell pattern in cell A1 in sheet 1 i would like the linked cell in sheet 2 to have the same contents & pattern. getting the linked cell to have the same contents as A1 in sheet 1 is no problem but is there a formula that i can include to automate this simple task?
thanks heaps - RG
hello all i tried to find an answer to this problem but had no luck. I am using excel to timetable classes. There are five master sheets (these cannot be merged) with weekly schedules and then linked to each master sheet are subsequent worksheets for each daily schedules, one per day of the week collecting what the teaching staff is doing on each day. My paste options as stated in knowledge knowledge base are as below suggesting it may be possible but
keep source formatting: Preserves all original formatting of the pasted selection. Preserves all formulas as well.
keep source column widths: preserves the column widths as well as all formulas and formatting.
Any suggestions appreciated. What you need to do is copy and paste the cells to the new sheet with no special copy. This will set up all of the cells with the proper format like merged cells and borders and color filled. You then highlight and delete what you just pasted. All text will disappear however the formatting will remain. Then you will repaste the desired information again and this time paste and link your data to the original. The data will fill into the proper places into the cells because the formatting is in place. So in a nutshell, copy paste delete repaste and link. |