LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott
 
Posts: n/a
Default Transfer Cell Formatting for linked cells

How do you get the cell formatting (color) to transfer to a linked cell?

Example: I have added color (red) to a particular cell (A1) in Sheet1. I
have linked cell (B2) in Sheet 2 to the red colored cell (A1) in Sheet1 (i.e.
=+Sheet1!A1). The cell value (A1) on Sheet1 transfers to the cell (B2) in
Sheet2, however the color (red) does not transfer to cell (B2) in Sheet2. I
want the cell value and the color (red) to transfer from cell (A1) Sheet1 to
the cell (B2) in Sheet2. Is there a way to get the cell formatting/color to
transfer along with the cell values from one linked cell to another? Thanks
for any help. Scott
 
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
How to insert a value in one cell into many cells Thomas Excel Worksheet Functions 17 October 18th 05 11:03 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
cell formatting problems jazzsax505 New Users to Excel 2 May 29th 05 10:30 PM
Trying to add conditional formatting to every other cell...GOING . trixiebme Excel Worksheet Functions 2 March 24th 05 01:55 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


All times are GMT +1. The time now is 05:59 PM.

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

About Us

"It's about Microsoft Excel"