| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In a function, How do I copy the cell color as well as text
All I want to do is to say for example that Cell A1 is equal to Cell G8 and
have A1 contain the same text as G8 and have the same fill colour |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In a function, How do I copy the cell color as well as text
In cell A1, put the formula =G8 and that will cause A1 to display the same
VALUE as is in cell G8. It will not transfer the cell color though. However, if cell G8 is colored by Conditional Formatting, then that same format can be applied to A1 and it's color will follow suite....... hth Vaya con Dios, Chuck, CABGx3 "Acapulcojo" wrote: All I want to do is to say for example that Cell A1 is equal to Cell G8 and have A1 contain the same text as G8 and have the same fill colour |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup text then copy over to new cell | Excel Worksheet Functions | |||
| Copy List of text to a single cell? | Excel Discussion (Misc queries) | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Hybrid Mode
