View Single Post
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 20 Jun 2005 09:51:03 -0700, GDC wrote:

If I use the concatenate function or =(cell1)&(cell2), is there a way to pick
up the formats of the original cells, e.g. underline or strikethru?


If that formatting is a result of conditional formatting, then you could use
the same conditional format formula within your concatenate formula.
Otherwise, you would have to use a Visual Basic macro.


--ron