Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formating Excel functions
Is there a way (when pulling a cell to another sheet by use of a formula)
that you can pull the same formatting from that cell to the sheet: Example, copy cell 1 from sheet 1 to cell 1 in sheet 2. I do not only want to copy the value/text, but the color formatting as well. Is this possible? |
#2
|
|||
|
|||
ya paste special
-- Hope it Helps! Jim India "MLRB" wrote in message ... Is there a way (when pulling a cell to another sheet by use of a formula) that you can pull the same formatting from that cell to the sheet: Example, copy cell 1 from sheet 1 to cell 1 in sheet 2. I do not only want to copy the value/text, but the color formatting as well. Is this possible? |
#3
|
|||
|
|||
Hi MLRB
No, not with a formula But you can use this example, this is for printing but you can use it for your problem also http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl "MLRB" wrote in message ... Is there a way (when pulling a cell to another sheet by use of a formula) that you can pull the same formatting from that cell to the sheet: Example, copy cell 1 from sheet 1 to cell 1 in sheet 2. I do not only want to copy the value/text, but the color formatting as well. Is this possible? |
#4
|
|||
|
|||
Thank you for your help.
"Ron de Bruin" wrote: Hi MLRB No, not with a formula But you can use this example, this is for printing but you can use it for your problem also http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl "MLRB" wrote in message ... Is there a way (when pulling a cell to another sheet by use of a formula) that you can pull the same formatting from that cell to the sheet: Example, copy cell 1 from sheet 1 to cell 1 in sheet 2. I do not only want to copy the value/text, but the color formatting as well. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
missing mouse functions in Excel xp | Setting up and Configuration of Excel | |||
Excel 2000 Functions | Excel Worksheet Functions | |||
What is the easiest way to learn math functions in excel . | Excel Worksheet Functions | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |