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

brianbale

New Member
Joined
Nov 18, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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

New Member
Joined
Nov 18, 2005
Messages
2
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,058
Messages
5,569,957
Members
412,300
Latest member
Chaneycr
Top