Formula Question

[Lambada]

What formula do I use if I want A1 to equal or copy just the fill color of A2?

Thank you.

 

[Brian from Maui]

Copy/Edit/Paste Special/Format

 

[Lambada]

No, that does not work. Sorry, I failed to mention that A2 is conditionally formatted to change color.
This message was edited by Lambada on 2002-08-24 11:22

 

[Brian from Maui]

Format/Cells/Pattern

 

[Lambada]

Sorry, A2 is the one conditionally formatted.

 

[Dave Patton]

On 2002-08-24 11:09, Lambada wrote:
What formula do I use if I want A1 to equal or copy just the fill color of A2?

Thank you.

does this help?


Sub Macro2()
With ActiveCell
Range("A6").Copy
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End With
End Sub

I used Macro recorder and then cleaned up the information.

 

[Lambada]

Thanks Dave, but what I want is a formula. I want the color to change instantly when A2 changes. Can it be done?

 

[Dave Patton]

On 2002-08-24 11:40, Lambada wrote:
Thanks Dave, but what I want is a formula. I want the color to change instantly when A2 changes. Can it be done?

Conditional format that cell based on the same criteria that you used to conditional format the first cell.

With the two cells selected, Conditional Format Formula (use relevant formula to replace =$A$2<10)

HTH Dave
This message was edited by Dave Patton on 2002-08-24 11:48

 

[Brian from Maui]

Lambada,

In addition to Dave's answer, you can also use absolute reference to your original formula in conditional formatting and copy the cell with the orignal formatting, click on the cell or cells you want and go to Edit/Paste Special/Format