Copy formating of a cell via a formula?

[millca]

Is there a way to write a formula to copy both the content AND
formatting of another cell?

I specifically want the text color to also be copied over.

Here's how I've copied the cells:

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

So how would I add the text color as well?

Thanks for any help you can send my way.

 

[Bob Greenblatt]

Is there a way to write a formula to copy both the content AND
formatting of another cell?

I specifically want the text color to also be copied over.

Here's how I've copied the cells:

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

So how would I add the text color as well?

Thanks for any help you can send my way.

You can¹t do that with a formula. But try conditional formatting, or a
custom number format to color the cell depending on its value.

 

[millca]

You can¹t do that with a formula. But try conditional formatting, or a
custom number format to color the cell depending on its value.

Thanks Bob for your input. However, perhaps there's another solution.
Let me clarify what I'm attempting to do:

I have a phone list that contains three columns (name, ph #, ph type).
Several of the names have multiple phones (up to four) so the name is
the same. This list is fairly long so on another worksheet, I've used
formulas to make the list printable in two columns of all three
initial columns (6 columns total).

On the master phone list worksheet, in order to sort it properly by
alphabet, the duplicate names all have to be the same but I only want
the top duplicate name to be seen. Any other names that are the same
below it, the text color is turned to white.

I need this same formatting to appear on the two column printable
list.

Here's an example:

Master List:
ABC Supply 253-774-2828 Work
Allen's Gutters 206-393-9298 Work
Allen's Gutters (this name is colored white so it disappears and yet
can still be sorted) 206-383-2828 Cell

Printable List (this is what I want it to look like):
ABC Supply 253-774-2828 Work
Allen's Gutters 206-393-9298 Work
206-383-2828 Cell

Does anyone know how I can do this? There is a VERY good chance I'm
going about this list entirely wrong. So any pointers would be greatly
appreciated. I've attempted to just do it via the printer options of
printing two pages on one page however it will NOT allow me to keep
the paper in portrait mode but always prints it on landscape which is
not acceptable.

Thanks!

 

[JE McGimpsey]

Here's an example:

Master List:
ABC Supply 253-774-2828 Work
Allen's Gutters 206-393-9298 Work
Allen's Gutters (this name is colored white so it disappears and yet
can still be sorted) 206-383-2828 Cell

Printable List (this is what I want it to look like):
ABC Supply 253-774-2828 Work
Allen's Gutters 206-393-9298 Work
206-383-2828 Cell

Does anyone know how I can do this? There is a VERY good chance I'm
going about this list entirely wrong. So any pointers would be greatly
appreciated. I've attempted to just do it via the printer options of
printing two pages on one page however it will NOT allow me to keep
the paper in portrait mode but always prints it on landscape which is
not acceptable.

Why not use the same Conditional Formatting on the name column(s) of the
Printable List as you do on the Master?

 

[Carl Witthoft]

Why not use the same Conditional Formatting on the name column(s) of the
Printable List as you do on the Master?

My impression was that he manually colored the names on the Master.
That said, he may be able to do what he wants with some sort of formula
in the Conditional Formatting dialog box like (assume the current cell
is A10)

IF ( vlookup(A10, A$1:A10,1) = "true", {color white}, {color black})
Where I've mangled the vlookup syntax, but you get the idea