This example demonstrates how to apply a three-color scale conditional formatting rule.
To apply a conditional formatting rule represented by the ColorScale3ConditionalFormatting object, access the collection of conditional formats from the Worksheet.ConditionalFormattings property and call the ConditionalFormattingCollection.AddColorScale3ConditionalFormatting method with the following parameters:
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-apply-conditional-formatting-to-a-range-of-cells-e4959
ConditionalFormattingCollection conditionalFormattings = worksheet.ConditionalFormattings; // Set the minimum threshold to the lowest value in the range of cells using the MIN() formula. ConditionalFormattingValue minPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.Formula, "=MIN($C$2:$D$15)"); // Set the midpoint threshold to the 50th percentile. ConditionalFormattingValue midPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.Percentile, "50"); // Set the maximum threshold to the highest value in the range of cells using the MAX() formula. ConditionalFormattingValue maxPoint = conditionalFormattings.CreateValue(ConditionalFormattingValueType.Number, "=MAX($C$2:$D$15)"); // Create the three-color scale rule to determine how values in cells C2 through D15 vary. Red represents the lower values, yellow represents the medium values and sky blue represents the higher values. ColorScale3ConditionalFormatting cfRule = conditionalFormattings.AddColorScale3ConditionalFormatting(worksheet.Range["$C$2:$D$15"], minPoint, Color.Red, midPoint, Color.Yellow, maxPoint, Color.SkyBlue);
The image below shows the result (the workbook is opened in Microsoft® Excel®). Cost distribution is shown using a gradation of three colors. Red represents the lower values, yellow represents the medium values and sky blue represents the higher values.