|
Copying Formatting and Value
I need lots of help people. I have a spreadsheet with about 20 worksheets. The first worksheet is the Master sheet. There is a column in the other 19 worksheets that links to the master. I want this column to copy the value, and also the formatting. When I say formatting, I really mean the background colors,and text colors that are on the master. The master will be changed periodically, and I want the other 19 sheets to auto update all of my formatting. The formula that I have so far is this, but this does not copy the formatting. =IF(ISBLANK(MASTER!$A$4),"",MASTER!$A$4) Can someone help me out. I would really appreciate it. Thanks -- haleswd ------------------------------------------------------------------------ haleswd's Profile: http://www.excelforum.com/member.php...o&userid=24787 View this thread: http://www.excelforum.com/showthread...hreadid=383484 |
You can't copy formating with a Formula
YOu will need code to do what you want. "haleswd" wrote: I need lots of help people. I have a spreadsheet with about 20 worksheets. The first worksheet is the Master sheet. There is a column in the other 19 worksheets that links to the master. I want this column to copy the value, and also the formatting. When I say formatting, I really mean the background colors,and text colors that are on the master. The master will be changed periodically, and I want the other 19 sheets to auto update all of my formatting. The formula that I have so far is this, but this does not copy the formatting. =IF(ISBLANK(MASTER!$A$4),"",MASTER!$A$4) Can someone help me out. I would really appreciate it. Thanks -- haleswd ------------------------------------------------------------------------ haleswd's Profile: http://www.excelforum.com/member.php...o&userid=24787 View this thread: http://www.excelforum.com/showthread...hreadid=383484 |
| All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com