# GoogleSheetsAddConditionalFormatRuleRequest

Adds one supported conditional-formatting rule.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsRequest.cs:297](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L297)

**Base**

`GoogleSheetsRequest`

**Modifiers**

sealed

Adds one supported conditional-formatting rule.

## Inheritance

- [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)
- GoogleSheetsAddConditionalFormatRuleRequest

Filter members 

Show inherited

## Constructors

`public GoogleSheetsAddConditionalFormatRuleRequest()` [#](#constructor-ctor)

[GoogleSheetsRequest.cs:297](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L297)

Creates a conditional-formatting request.

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public string SheetName { get; set; }` [#](#property-sheetname)

[GoogleSheetsRequest.cs:297](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L297)

Gets or sets the worksheet containing the rule.

`public string A1Range { get; set; }` [#](#property-a1range)

[GoogleSheetsRequest.cs:299](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L299)

Gets or sets the formatted range in A1 notation.

`public int Index { get; set; }` [#](#property-index)

[GoogleSheetsRequest.cs:301](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L301)

Gets or sets the rule insertion index.

`public string ConditionType { get; set; }` [#](#property-conditiontype)

[GoogleSheetsRequest.cs:303](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L303)

Gets or sets the Sheets boolean-condition type.

`public IReadOnlyList<string> Values { get; set; }` [#](#property-values)

[GoogleSheetsRequest.cs:305](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L305)

Gets or sets the condition's argument values.

`public GoogleSheetsCellStyle? Format { get; set; }` [#](#property-format)

[GoogleSheetsRequest.cs:307](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L307)

Gets or sets the formatting applied when the condition matches.

## Inherited Properties

`public string Kind { get; }` [#](#property-kind)

[GoogleSheetsRequest.cs:24](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L24)

Inherited from [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)

<!-- PowerForge markdown artifact sha256:B8BBF8539721AFBE2879B8D38F6A8D441F3C6FE58562B7FB1A91554FA21C7035 -->
