Obtain Cell Formatting in Cell Referencing?

A

Al Franz

When you reference a cells contents in another cell is there anyway to also
bring over such things as the background colors, bold, font, etc?
 
J

JE McGimpsey

Not with formulae, which can only return values to their calling cells.
You can replace the formula with an event macro that can format the cell
if you wish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
More than 3 Conditional Formals - EXCEL 2000 10
count cells with diagonal borders 3
functions to change color of fonts or cell backgrounds? 1
Conditional Formatting Help 1
losing date format when referencing date cell on another sheet and 3
vba to convert htm tags 2
conditional format - table - cell empty return default color 1

Top