Copying Formatting and Value

  • Thread starter Thread starter haleswd
  • Start date Start date
H

haleswd

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
 
You can't copy formating with a Formula
YOu will need code to do what you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups - how to obtain data from a master spreadsheet into another 5
copy sheets 3
Merge Multiple workbook sheets into one workbook 0
Stop linked cells from changing when insert new row? 1
I want a Master Worksheet that other Workbooks use as a template? 3
copying data from master ti individual sheets 3
Excel 03 VLOOKUP hyperlink referencing and formatting 3
Copy all formats and objects 5

Back
Top