Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell=Cell to include formatting
How can I have a cell equal another cell AND also include the formatting of the text from that cell, like Bold, Color, etc? For example, this formula on Sheet2 DOES show the data from Sheet1, but NOT the formatting: =Sheet1!B3 Thanks! -- rerhart ------------------------------------------------------------------------ rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138 View this thread: http://www.excelforum.com/showthread...hreadid=504147 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell=Cell to include formatting
A formula cannot change any formatting. It can only return a
single value to the cell. You might be able to use Conditional Formatting from the Format menu to accomplish what you want. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "rerhart" wrote in message ... How can I have a cell equal another cell AND also include the formatting of the text from that cell, like Bold, Color, etc? For example, this formula on Sheet2 DOES show the data from Sheet1, but NOT the formatting: =Sheet1!B3 Thanks! -- rerhart ------------------------------------------------------------------------ rerhart's Profile: http://www.excelforum.com/member.php...fo&userid=8138 View this thread: http://www.excelforum.com/showthread...hreadid=504147 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell=Cell to include formatting
Formulas return values only.
Formatting is a seperate step using Paintbrush or manually. Gord Dibben MS Excel MVP On Mon, 23 Jan 2006 13:16:38 -0600, rerhart wrote: How can I have a cell equal another cell AND also include the formatting of the text from that cell, like Bold, Color, etc? For example, this formula on Sheet2 DOES show the data from Sheet1, but NOT the formatting: =Sheet1!B3 Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) |