The ConditionalFormatting class encapsulates all settings of Conditional Formatting. The class can be used to make a copy ConditionalFormatting settings.

For example:

ConditionalFormatting cf = sheet.getConditionalFormattingAt(index);
newSheet.addConditionalFormatting(cf);

or to modify existing Conditional Formatting settings (formatting regions and/or rules).

Use org.apache.poi.ss.usermodel.Sheet#getSheetConditionalFormatting() to get access to an instance of this class.

To create a new Conditional Formatting set use the following approach:

// Define a Conditional Formatting rule, which triggers formatting
// when cell's value is greater or equal than 100.0 and
// applies patternFormatting defined below.
ConditionalFormattingRule rule = sheet.createConditionalFormattingRule(
    ComparisonOperator.GE,
    "100.0", // 1st formula
    null     // 2nd formula is not used for comparison operator GE
);

// Create pattern with red background
PatternFormatting patternFmt = rule.cretePatternFormatting();
patternFormatting.setFillBackgroundColor(IndexedColor.RED.getIndex());

// Define a region containing first column
Region [] regions =
{
    new Region(1,(short)1,-1,(short)1)
};

// Apply Conditional Formatting rule defined above to the regions
sheet.addConditionalFormatting(regions, rule);