| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy colour
Try Sub CopyColor() Range("B2").Select With Selection.Interior .Pattern = Range("A2").Interior.Pattern .Color = Range("A2").Interior.Color End With End Sub "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 | |||
| 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 | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Linear Mode
