crmpicco
06-01-2005, 03:23 AM
Is there a way i can colour From LEFT to RIGHT of a cell starting from where a COLON is found?
If Trim$(Range(sRange).Text) <> "" Then
iColonPos = InStr(Trim(Range(sRange).Text), ":")
Range(sRange).Interior.ColorIndex = iColour
End If
TIA.
If Trim$(Range(sRange).Text) <> "" Then
iColonPos = InStr(Trim(Range(sRange).Text), ":")
Range(sRange).Interior.ColorIndex = iColour
End If
TIA.