Conditional Format

[kop442000]

Hi guys

Is it possibl to merge/unmerge cells as part of a conditional format? Or is it something I would have to do with a macro or something like that?

Thanks for any replies,
Kop.

 

[Gerald Higgins]

It's not an option in basic conditional formating. A macro might do it.

 

[Lewiy]

You cannot do this via conditional formatting, however, here is an example of some event code which will merge a cell with the cell to its right if you enter the value 10 in it:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = 10 Then
    Range(Target.Address & ":" & Target.Offset(0, 1).Address).MergeCells = True
End If
End Sub

 

[kop442000]

ok well I think I can work with that code to get something near what I want..

Could you just give me the same example as above, but merging if I was entering "10" in the cell D7 rather that in the target cell.

thank you!

 

[kop442000]

ok well I think I can work with that code to get something near what I want..

Could you just give me the same example as above, but merging say cell G3 if I was entering "10" in the cell D7?
thank you!

 

[Lewiy]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$7" Then
    If Target.Value = 10 Then
        Range(Target.Address & ":" & Target.Offset(0, 1).Address).MergeCells = True
    End If
End If
End Sub

 

[kop442000]

but that still merges D7 right?

I need cell G5 to merge if D7 gets "10" typed in it... could you amend the code for that please?

Thank you,
kop.

 

[Norie]

kop


How can you merge 1 cell?

 

[kop442000]

Because Lewiy originally talked about his code that "will merge a cell with the cell to its right".

So I was just refering to the cell to be merged to it's right.

My actual spreadsheet will require a few different merges but I just want to get a good idea of the code I need.