How to copy FORMAT of a cell DYNAMICALLY along with content?

[brianbale]

Fairly technical question -- hope someone can help:

Let's say I have a formula in cell A1: "=IF(condition,B4,B5)". Normally, the *value* of either cell B4 or B5 would appear in target cell A1. Let's assume B4 and B5 have different formatting. Is there any way to copy the formating of the cell along with the content?

In reality, the result of my formula can be about a dozen different cells -- not just two -- each with a distinct color background. For that reason, Excel's "conditional formatting" is not working for me. Conditional Formatting only allows me to choose up to three different formats for the cell.

Can anyone help? Thanks!

Brian Bale

 

[Juan Pablo González]

Try this:

Select the cell(s) that you want to copy
Press and hold the Shift key
Go to the Edit menu, and select "Copy Picture"
Now Paste where you want this cell. You'll have to adjust this image.
With the shape selected, click in the Formula Bar, type = and then point and click to the cell that you copied.

It should now reflect the value and the format of the original cell.

 

[brianbale]

Thanks, but...

I have no problem copying formats MANUALLY. But I need to copy formats of cells (along with contents) DYNAMICALLY, as the result of a FORMULA.

Any thoughts?