PDA

View Full Version : [SOLVED] Pick the fillcolor of a cell



wmr
11-30-2015, 09:00 AM
Hello,

I do not only want to connect cell content, but fillcolor as well.

So, for content I use f.e. In cell A1 I enter: = A2

A2 is green. Now I want cell A1 green as well.

Is that possible?

kind regands
Willem

jolivanes
11-30-2015, 11:22 PM
Something like this?
Fires when you enter your formula in a cell in Column A and hit the "Enter" button.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then ActiveCell.Offset(-1).Interior.Color = ActiveCell.Offset(-1, 1).Interior.Color
End Sub

wmr
12-01-2015, 04:41 AM
Thanks, that works.

kind regards,
Willem