// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java // Path to source file String dataDir = Utils.getSharedDataDir(SetPattern.class) + "data/"; // Instantiating a Workbook object Workbook workbook = new Workbook(); Worksheet sheet = workbook.getWorksheets().get(0); // Adds an empty conditional formatting int index = sheet.getConditionalFormattings().add(); FormatConditionCollection fcs = sheet.getConditionalFormattings().get(index); // Sets the conditional format range. CellArea ca = new CellArea(); ca.StartRow = 0; ca.EndRow = 5; ca.StartColumn = 0; ca.EndColumn = 3; fcs.addArea(ca); // Adds condition. int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100"); // Sets the background color. FormatCondition fc = fcs.get(conditionIndex); Style style = fc.getStyle(); style.setPattern(BackgroundType.REVERSE_DIAGONAL_STRIPE); style.setForegroundColor(Color.fromArgb(255, 255, 0)); style.setBackgroundColor(Color.fromArgb(0, 255, 255)); fc.setStyle(style);