skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • AI Coding Assistants
    • Embedded Reporting
    • Document Processing Libraries
    • SSO Account Sign-in

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    AI Coding Assistants

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • Roadmap
    • Release History
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class ConditionalFormattingRule

Base class for rules that evaluate cell values and apply formatting when specific conditions are met, enabling dynamic visual feedback in worksheets.

Inheritance
System.Object
ConditionalFormattingRule
ColorScaleRule
ConditionalFormattingDxfRule
DataBarRule
IconSetRule
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public abstract class ConditionalFormattingRule

Constructors

ConditionalFormattingRule()

Initializes a new conditional formatting rule with default priority and evaluation behavior.

Declaration
protected ConditionalFormattingRule()

Methods

AutoFail(ICellValue)

Returns a failure resolution result (0.0) regardless of the cell value, used for rules that never apply.

Declaration
protected static double AutoFail(ICellValue value)
Parameters
ICellValue value

Does not serve any purpose

Returns
System.Double

0d

AutoSuccess(ICellValue)

Returns a successful resolution result (1.0) regardless of the cell value, used for rules that always apply.

Declaration
protected static double AutoSuccess(ICellValue value)
Parameters
ICellValue value

Does not serve any purpose

Returns
System.Double

1d

Resolve(ICellValue)

Evaluates the cell value against the rule's condition and returns a numeric result indicating whether the condition is met (positive for match, zero for no match).

Declaration
protected virtual double Resolve(ICellValue value)
Parameters
ICellValue value

The cell value that is resolved by the rule

Returns
System.Double

SwapPriority(ConditionalFormattingRule)

Exchanges the evaluation priority with another rule, affecting the order in which rules are applied when multiple rules match.

Declaration
public void SwapPriority(ConditionalFormattingRule rule)
Parameters
ConditionalFormattingRule rule

Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.