concatenating cells with their formats

Ron Rosenfeld

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
REVISED ?? - populate limited cells w/ set value	Jane	Excel Worksheet Functions	1	March 19th 05 02:29 PM
Blank Cells in Pivot Tables	Greg	Excel Discussion (Misc queries)	1	March 16th 05 09:23 PM
Seed date formats to different year in different cells	KR	Excel Discussion (Misc queries)	4	February 12th 05 12:02 AM
Protected cells -automatically format to a different color	Fred Evans	Excel Discussion (Misc queries)	9	December 3rd 04 12:59 PM
copy group of cells to another group of cells using "IF" in third	Chuckak	Excel Worksheet Functions	2	November 10th 04 06:04 PM

All times are GMT +1. The time now is 06:55 AM.

Menu

About Us