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