|
本帖最后由 wanao2008 于 2016-7-5 20:23 编辑
经测试可以满足你的要求:
方法:Sheet1表格里添加”SelectionChange“事件。
代码如下:- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- x = Target.Row
- y = Target.Column
- If Target.Value <> "" Then
- Range("B7:BE9").Interior.Color = xlNone
- Target.Interior.Color = vbYellow
- If Target.Column > 11 And Target.Column < 47 Then
- Range(Target.Offset(0, 1), Target.Offset(0, 11)).Interior.Color = vbYellow
- Range(Target.Offset(0, 1), Target.Offset(0, 10)).Interior.Color = vbRed
- Range(Target.Offset(0, -1), Target.Offset(0, -10)).Interior.Color = vbRed
- ElseIf Target.Column > 46 Then
- If Target.Column = 57 Then
- Range(Target.Offset(0, -1), Target.Offset(0, -10)).Interior.Color = vbRed
- Else
- Range(Target.Offset(0, -1), Target.Offset(0, -10)).Interior.Color = vbRed
- Range(Target.Offset(0, 1), Target.Offset(0, 57 - y)).Interior.Color = vbRed
- End If
- Else
- If Target.Column = 2 Then
- Range(Target.Offset(0, 1), Target.Offset(0, 10)).Interior.Color = vbRed
- Else
- Range(Target.Offset(0, 1), Target.Offset(0, 10)).Interior.Color = vbRed
- Range(Target.Offset(0, -1), Target.Offset(0, 2 - y)).Interior.Color = vbRed
- End If
-
- End If
- End If
- End Sub
复制代码 |
|