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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,996
Messages
5,834,785
Members
430,322
Latest member
excelnoobnoob

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top