Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula that perfectly copies data from another cell (with color)?
I need to refer to another cell along with the background formatting.
In other words if A(1) has a value of 200, and the background is red, I want another cell to point to A(1) as well as maintain the formatting of A(1). Thanks Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula that perfectly copies data from another cell (with color)?
Not possible with a formula.
You can use the change event in the worksheet module but if you only change the color of the cell the change event will not run Something like this Copy format and value of A1 to C1 if you change A1 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("A1"), Target) Is Nothing Then Target.Copy Range("C1") End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Ron Wood" wrote in message om... I need to refer to another cell along with the background formatting. In other words if A(1) has a value of 200, and the background is red, I want another cell to point to A(1) as well as maintain the formatting of A(1). Thanks Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula copies value from original cell only | Excel Worksheet Functions | |||
Type in one cell and data copies into another cell | Excel Discussion (Misc queries) | |||
Macro or Formula that copies and moves data? | Excel Discussion (Misc queries) | |||
Is There a Formula that copies another cell exactly in Excel? | Excel Discussion (Misc queries) | |||
I need a macro that copies that data from one cell on one sheet to a cell on another? | Excel Programming |