|
本帖最后由 eking_tang 于 2014-3-24 11:44 编辑
因为数据处理量大,经常看错行,求哪位老师能帮忙用VBA帮忙写一个聚光灯的代码啊?
感谢先
eking_tang 发表于 2014-3-24 08:08
大師~~要的就是這個效果~~太感謝了~~
請問如果要加上列也顯示高亮要怎麼加啊?
不勝感激 - Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
- On Error Resume Next
- Sh.Cells.FormatConditions.Delete
- With Target.EntireRow.FormatConditions
- .Delete
- .Add xlExpression, , "TRUE"
- .Item(1).Interior.ColorIndex = 28
- End With
- With Target.EntireColumn.FormatConditions
- .Delete
- .Add xlExpression, , "TRUE"
- .Item(1).Interior.ColorIndex = 28
- End With
- End Sub
复制代码
|
|