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
|