View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Obtain Cell Formatting in Cell Referencing?

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.

In article ,
"Al Franz" wrote:

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?