- ·上一篇:excel表格怎么设置连减
- ·下一篇:怎么在excel表格做线性图像
excel表格怎么更改选项框
2024-09-20 15:44:23
1.在excel中如何改变选定单元格边框?
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) On Error Resume Next Cells.FormatConditions.Delete With Target.FormatConditions .Delete .Add xlExpression, , "TRUE" .Item(1).Interior.ColorIndex = 6 End With End Sub。