Copy cell contents and formatting

**garyk007** · 10-21-2007, 09:44 PM

Hi Everyone

I am currently using the following formula to copy the contents of a cell, even if the cell is blank, to another cell.

=IF(A1="","",A1)

The question is... if the original cell changes from normal to bold how do you get the new cell to copy the formatting as well?

Thanks

**garyk007** · 10-21-2007, 11:40 PM

Hi Everyone

I think I posted this in the wrong forum ... sorry.
Hope this is in the right one.

I am currently using the following formula to copy the contents of a cell, even if the cell is blank, to another cell.

=IF(A1="","",A1)

The question is... if the original cell changes from normal to bold how do you get the new cell to copy the formatting as well?

Thanks

**davesexcel** · 10-21-2007, 11:58 PM

this would require VBA

Please Login or Register  to view this content.

This code belongs in the worksheet module
Right click on the sheet tab at the bottom of the screen, select view codes, paste the code in that window
Now whenever A1 changes the code kicks in