Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy colour
If you are familiar with VBA (Macros) the following code will copy the color
of F7 to A1 on the active worksheet: Sub copycolor() ActiveSheet.Range("A1").Interior.ColorIndex = ActiveSheet.Range("F7").Interior.ColorIndex ActiveSheet.Range("A1").Interior.Pattern = ActiveSheet.Range("F7").Interior.Pattern End Sub If you are not familiar with VBA then more information about what you are trying to do would be necessary. Tom "assaf1978" wrote: Hi, How can I copy a colour of a cell to another cell, using a function or a macro? Thanks, Assaf. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy colour | Excel Discussion (Misc queries) | |||
How to make a cell copy the fill colour of another cell | Excel Worksheet Functions | |||
How to make a cell copy the info from another (background colour i | New Users to Excel | |||
excel - formula to copy the cell contents and colour. Possible? | Excel Discussion (Misc queries) | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel |