Class

DifferentialFormatting

Initializes a new DifferentialFormatting that can overlay formatting properties on cells when conditional formatting rules apply.

Declaration

public DifferentialFormatting()

Gets or sets the bottom border style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder BottomBorder { get; set; }

Property Value

Gets or sets the number format to apply when the conditional formatting rule is satisfied.

Declaration

public CellValueFormat CellValueFormat { get; set; }

Property Value

Gets or sets the diagonal down border (top-left to bottom-right) style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder DiagonalDownBorder { get; set; }

Property Value

Gets or sets the diagonal up border (bottom-left to top-right) style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder DiagonalUpBorder { get; set; }

Property Value

Gets or sets the background fill (pattern or gradient) to apply when the conditional formatting rule is satisfied.

Declaration

public IFill Fill { get; set; }

Property Value

Gets or sets the font family to apply when the conditional formatting rule is satisfied.

Declaration

public ThemableFontFamily FontFamily { get; set; }

Property Value

Gets or sets the font size to apply when the conditional formatting rule is satisfied.

Declaration

public double FontSize { get; set; }

Property Value

Gets or sets the text color to apply when the conditional formatting rule is satisfied.

Declaration

public ThemableColor ForeColor { get; set; }

Property Value

Gets or sets whether to apply bold text formatting when the conditional formatting rule is satisfied.

Declaration

public bool IsBold { get; set; }

Property Value

Gets or sets whether to apply italic text formatting when the conditional formatting rule is satisfied.

Declaration

public bool IsItalic { get; set; }

Property Value

Gets or sets the left border style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder LeftBorder { get; set; }

Property Value

Gets or sets the right border style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder RightBorder { get; set; }

Property Value

Gets or sets the top border style and color to apply when the conditional formatting rule is satisfied.

Declaration

public CellBorder TopBorder { get; set; }

Property Value

Gets or sets the underline style to apply when the conditional formatting rule is satisfied.

Declaration

public UnderlineType Underline { get; set; }

Property Value

Compares this differential formatting with another object and returns true if all formatting properties match.

Declaration

public override bool Equals(object obj)

Parameters

Returns

Overrides object.Equals(object)

Computes a hash code based on all defined formatting properties for use in collections.

Declaration

public override int GetHashCode()

Returns

Overrides object.GetHashCode()