# Format an Excel

### Overview

This procedure formats cells in an Excel worksheet by applying various formatting options such as background color, font color, font weight, and font size to specified cell ranges.

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>format the excel</code></summary>

#### What does it do?

Begins formatting cells in the Excel file.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the excel** file must be defined in the automation.

</details>

<details>

<summary><code>the worksheet name is "worksheet-name"</code></summary>

#### What does it do?

Specifies which worksheet to format.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — Replace **worksheet-name** with the name of an existing worksheet.

#### Example

```
the worksheet name is "Sheet1"
```

</details>

<details>

<summary><code>the cell range is r</code></summary>

#### What does it do?

Specifies which cells to format.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — Replace **r** with a cell range (e.g., "A1:B10") or single cell (e.g., "A1").

#### Example

```
the cell range is "A1:C5"
```

</details>

<details>

<summary><code>the bg color is "bg-color-code"</code></summary>

#### What does it do?

Sets the background color of the cells.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **bg-color-code** with a hex color code *(without "#")*.

#### Example

```
the bg color is "FFFF00"
```

</details>

<details>

<summary><code>the font color is "font-color-code"</code></summary>

#### What does it do?

Sets the font color of the cells.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **font-color-code** with a hex color code *(without "#")*.

#### Example

```
the font color is "000000"
```

</details>

<details>

<summary><code>the font weight is "font-weight"</code></summary>

#### What does it do?

Sets the font weight/style.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **font-weight** with "bold", "italic", "underline", or "strike".

#### Example

```
the font weight is "bold"
```

</details>

<details>

<summary><code>the font size is s</code></summary>

#### What does it do?

Sets the font size in points.

#### Where does it go?

Indented under `format the excel`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **s** with a numeric value.

#### Example

```
the font size is 14
```

</details>

### Examples

#### 1. Format Header Row with Background and Bold Font

Formats header cells with yellow background and bold text.

```
format the excel
    the worksheet name is "Sheet1"
    the cell range is "A1:C5"
    the bg color is "FFFF00"
    the font color is "000000"
    the font weight is "bold"
```

#### 2. Format Data Column with Font Size and Color

Formats a data column with larger font size and blue color.

```
format the excel
    the worksheet name is "Sheet1"
    the cell range is "A1:A10"
    the font size is 14
    the font color is "0000FF"
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-worksheet/format-an-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.