Tutorial by Examples

Syntax: FormatConditions.Add(Type, Operator, Formula1, Formula2) Parameters: NameRequired / OptionalData TypeTypeRequiredXlFormatConditionTypeOperatorOptionalVariantFormula1OptionalVariantFormula2OptionalVariant XlFormatConditionType enumaration: NameDescriptionxlAboveAverageConditionAbove av...

Remove all conditional format in range: Range("A1:A10").FormatConditions.Delete Remove all conditional format in worksheet: Cells.FormatConditions.Delete

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...