EasyXLS

ConditionalFormatting.bas

Attribute VB_Name = "ConditionalFormatting"
Public CONDITIONALFORMATTING_CONDITIONAL_FORMATTING_TYPE_COMPARE_CELL_VALUE As Long
Public CONDITIONALFORMATTING_CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA As Long
Public CONDITIONALFORMATTING_OPERATOR_NO_COMPARATION As Long
Public CONDITIONALFORMATTING_OPERATOR_BETWEEN As Long
Public CONDITIONALFORMATTING_OPERATOR_NOT_BETWEEN As Long
Public CONDITIONALFORMATTING_OPERATOR_EQUAL_TO As Long
Public CONDITIONALFORMATTING_OPERATOR_NOT_EQUAL_TO As Long
Public CONDITIONALFORMATTING_OPERATOR_GREATER_THAN As Long
Public CONDITIONALFORMATTING_OPERATOR_LESS_THAN As Long
Public CONDITIONALFORMATTING_OPERATOR_GREATER_THAN_OR_EQUAL_TO As Long
Public CONDITIONALFORMATTING_OPERATOR_LESS_THAN_OR_EQUAL_TO As Long

Sub Initialize()
    CONDITIONALFORMATTING_CONDITIONAL_FORMATTING_TYPE_COMPARE_CELL_VALUE = 1
    CONDITIONALFORMATTING_CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA = 2
    CONDITIONALFORMATTING_OPERATOR_NO_COMPARATION = 0
    CONDITIONALFORMATTING_OPERATOR_BETWEEN = 1
    CONDITIONALFORMATTING_OPERATOR_NOT_BETWEEN = 2
    CONDITIONALFORMATTING_OPERATOR_EQUAL_TO = 3
    CONDITIONALFORMATTING_OPERATOR_NOT_EQUAL_TO = 4
    CONDITIONALFORMATTING_OPERATOR_GREATER_THAN = 5
    CONDITIONALFORMATTING_OPERATOR_LESS_THAN = 6
    CONDITIONALFORMATTING_OPERATOR_GREATER_THAN_OR_EQUAL_TO = 7
    CONDITIONALFORMATTING_OPERATOR_LESS_THAN_OR_EQUAL_TO = 8
End Sub

EasyXLS Excel components:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Download EasyXLS™ Excel Component for VB6

File formats:

Office 365
MS Excel 2021 - 2024
MS Excel 2007 - 2019
MS Excel 97 - 2003
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT