CellFormat CellFormat CellFormat Interface

Definition

Represents the search criteria for the cell format.

public interface class CellFormat
[System.Runtime.InteropServices.Guid("00024450-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface CellFormat
Public Interface CellFormat
Attributes

Remarks

Use the FindFormat or ReplaceFormat properties of the Application object to return a CellFormat object.

You can use the Borders, Font, or Interior properties of the CellFormat object to define the search criteria for the cell format.

Properties

AddIndent AddIndent AddIndent

True if text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Borders Borders Borders

Allows the user to set or return the search criteria based on the cell's border format.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Font Font Font

Returns a Font object, allowing the user to set or return the search criteria based on the cell's font format.

FormulaHidden FormulaHidden FormulaHidden

True if the formula will be hidden when the worksheet is protected. Returns Null if the specified range contains some cells with FormulaHidden equal to True and some cells with FormulaHidden equal to False.

HorizontalAlignment HorizontalAlignment HorizontalAlignment

Returns or sets the horizontal alignment for the specified object.

IndentLevel IndentLevel IndentLevel

Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15.

Interior Interior Interior

Returns an Interior object allowing the user to set or return the search criteria based on the cell's interior format.

Locked Locked Locked

True if the object is locked; False if the object can be modified when the sheet is protected. Returns Null if the specified range contains both locked and unlocked cells.

MergeCells MergeCells MergeCells

True if the range or style contains merged cells.

NumberFormat NumberFormat NumberFormat

Returns or sets the format code for the object. Returns Null if all cells in the specified range don't have the same number format.

NumberFormatLocal NumberFormatLocal NumberFormatLocal

Returns or sets the format code for the object as a string in the language of the user.

Orientation Orientation Orientation

The text orientation. Can be an integer value from –90 to 90 degrees.

Parent Parent Parent

Returns the parent object for the specified object.

ShrinkToFit ShrinkToFit ShrinkToFit

True if text automatically shrinks to fit in the available column width. Returns Null if this property isn’t set to the same value for all cells in the specified range.

VerticalAlignment VerticalAlignment VerticalAlignment

Returns or sets the vertical alignment of the specified object.

WrapText WrapText WrapText

True if Microsoft Excel wraps the text in the object. Returns Null if the specified range contains some cells that wrap text and other cells that don’t.

Methods

Clear() Clear() Clear()

Clears the criteria set in the FindFormat and ReplaceFormat properties.

Applies to