Function MergeText(c1 As Range, c2 As Range)
With Application.ThisCell
MergeText = c1.Text & c2.Text
Select Case Month(c2.Value)
Case 1, 2, 3
.Font.Color = vbRed
Case 4, 5, 6
.Font.Color = vbGreen
Case 7, 8, 9
.Font.Color = vbBlue
Case 10, 11, 12
.Font.Color = vbMagenta
End Select
End With
End Function