Set ws=ThisWorkbook.Sheets("Sheet1")Set rng=ws.Range("A1:C10")With rng.FormatConditions.Add(Type:=xlCellValue,Operator:=xlGreaterThan,Formula1:=50).SetFirstPriority.Interior.ColorIndex=6' 设置背景颜色为红色 End With End Sub 在这个例子中,`Type`被设为`xlCellValue`,`Operator`被设为`xlGreate...
Now that we’ve gone over the basic use of the “does not equal” operator, let’s take a look at how to do “does not equal” with other functions in Excel. The values that the Excel “not equal to” operator returns can help in building IF, OR and NOT functions. Example 1: “...
Operator:=xlLessEqual, Formula1:="10" Selection.FormatConditions(1).Font.ColorIndex = 3 MsgBox "恢复原状" Selection.FormatConditions(1).Font.ColorIndex = xlAutomatic End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - [示例22...
VBASigned True if the Visual Basic for Applications project for the specified workbook has been digitally signed. Read-only Boolean. VBProject Returns a VBProject object that represents the Visual Basic project in the specified workbook. Read-only. WebOptions Returns the WebOptions collection, ...
Operator可选Variant数据验证运算符。 可以是以下XlFormatConditionOperator常量之一:xlBetween、xlEqual、xlGreater、xlGreaterEqual、xlLess、xlLessEqual、xlNotBetween或xlNotEqual。 Formula1可选Variant数据验证公式中的第一部分。 值不得超过 255 个字符。
VBA Language Reference Microsoft Access Visual Basic Reference Microsoft Excel Visual Basic Reference Welcome to the Microsoft Excel 2003 VBA Language Reference Microsoft Excel Object Model What's New Concepts Reference Collections Objects Methods Properties Events Enumerations Microsoft Excel Constants Microsoft...
VBASigned VBProject WebOptions Windows Worksheets WritePassword WriteReserved WriteReservedBy XmlMaps XmlNamespaces Methods _Worksheet AboveAverage Action Actions AddIn AddIns AddIns2 Adjustments AllowEditRange AllowEditRanges AppEvents AppEvents_AfterCalculateEventHandler AppEvents_Event AppEvents_New...
Operator可选Variant数据验证运算符。 可以是以下XlFormatConditionOperator常量之一:xlBetween、xlEqual、xlGreater、xlGreaterEqual、xlLess、xlLessEqual、xlNotBetween或xlNotEqual。 Formula1可选Variant数据验证公式中的第一部分。 值不得超过 255 个字符。
句法(Type, Operator, Formula1, Formula2)expressionfile:///E|/个人/研究/成果/VB/资料/ExcelVBA方法属性大全(大量实例)/(第 14/134 页)2009-8-14 上午 01:45:30 VBA 语言参考必选。该表达式返回 FormatConditions 对象。TypeLong 类型,必选。指定条件格式是基于单元格的值还是基于表达式。 可为下列 Xl...
VBASigned VBProject WebOptions Windows Worksheets WritePassword WriteReserved WriteReservedBy XmlMaps XmlNamespaces Methods Events WorkbookConnection WorkbookEvents WorkbookEvents_ActivateEventHandler WorkbookEvents_AddinInstallEventHandler WorkbookEvents_AddinUninstallEventHandler WorkbookEvents_AfterSaveEventHandler Work...