Hi,

I have wrote a script that validates the values of different cells.
When it detects a problem it changes the background colour of the
offending cell.

To reset the background colour back to it's original colour I've added
this script to the worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target.Interior
If .ColorIndex = 7 Then
.ColorIndex = 36
End If
End With
End Sub

This works on the cells that aren't merged but doesn't on those that
are. How do I change the color ot the merged cells?

Thanks in advance

Rich