Referencing master worksheet

[MikeM2468]

I have an 2007 Excel spreadsheet. One sheet is a master list of "stuff". For the second sheet, I'd like for it to be a carbon copy of the master sheet, but with some conditional formatting on the cells (basically alternating colors for each row). The problem that I'm having is if I use something like

=IF(Master!A1=0,"",Master!A1)

it doesn't reference the formatting of the text in the master sheet. By that I mean if something is bold in the master, it doesn't show as bold in the new sheet. Is there a way to do this? Note that I use the IF above because blank cells come over as 0's.

 

[SkipVought]

hi,

You cannot return formats with a formula; only VALUES.

What is the purpose of the "carbon copy" with Conditional Formatting, which makes it not a "carbon copy"?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MikeM2468]

It's a sheet where some people want it to print with highlighted alternate lines and some people want it without the lines. But I only want to update one.

Is there some sort of one-click macro that I can create to do it?

 

[SkipVought]

hi,

Multiple "identical" sheets -- NOT a good idea, IMNSHO.

Use a macro on the Master Sheet to produce the various formats you need. SIMPLE!

Use your macro recorder to get started. Post back with your recorded code for help customizing.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MikeM2468]

I'm not at all familiar with macros. All I have is the conditional format rule:

=MOD(ROW(),2)=1

applied to =$1:$65536


I've been able to toggle the conditional format on and off with a key cell, but I'd rather a button or something.

 

[SkipVought]

Make the button change the key cell. SIMPLE!

Try some stuff! Be adventuresome! Post back with your code and questions.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}