---
description: Set the style of excel range.
---

# Apply Style

Set the style within the specified excel range.Set font style and cell style of the specified excel range.

{% hint style="info" %}
This activity can only be used after the [Open Excel File activity.](../open-excel-file)
{% endhint %}

### Input

* **Input** : [`ExcelHandle Variable`](../../../../../getting-started/rpa-studio/variables#excelhandle) ![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  A variable name that references the opened excel filehandle.
* **Sheet Name** : [`String Argument`](../../../../../getting-started/rpa-studio/arguments#string)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  The name of the sheet in which the range color is to be set.
* **Range** : [`String Argument`](../../../../../getting-started/rpa-studio/arguments#string)![](https://1935494318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M927xRZSEM57y2sBcm3%2Fuploads%2Fgit-blob-20e90e25afa096ee0833e242a7763776d12b4591%2Fimage.png?alt=media)\
  The cell range in which the color is to be set.

{% hint style="info" %}
The range is specified in `A1:E10` or `A1` format. `A1:E10` will select all cells of the first five columns from row 1 to 10. `A1` will select first cell from first row.
{% endhint %}

**Font Style**

* **Font Name** :\
  The font name to be set to the range of data. system font names are shown in the dropdown.
*   **Font Size** : [`Integer Argument`](../../../../getting-started/rpa-studio/arguments)

    The font size to be set to the range of data.
* **Font Weight** :\
  The font Weight to be set to the range of data.
  * Bold - set the specified range of data as bold.
  * Normal - set the specified range of data as normal font weight.
* **Font Style** :\
  The font style to be set to the range of data.
  * Italic - set the specified range of data as italic.
  * Underline - underline the specified range of data.
  * None - font style is not set.
* **Font Color** :\
  The font color to be set to the range of data. The default value is Not Set.
* **Cell Background Color** :\
  The background cell color to be set to the range of data. The default value is Not Set.

**Cell Style**

* **Cell Border** :\
  The cell border to be set to the range of data.
  * BottomBorder - set the border at the bottom of the range.
  * TopBorder - set the border at the top of the range.
  * LeftBorder - set the border at the left of the range.
  * RightBorder - set the border at the right of the range.
  * NoBorder - the border will not be set.
  * OutsideBorder - set the border at the outside of the range.
  * AllBorders - set all borders of the range.
* **Border Thickness** :\
  The border thickness to be set to the range of data.
  * Hairline - set the border a hairline.
  * Thin - Set the border a thin line.
  * Medium - set the border as medium thickness.
  * Thick - set the border as a thick line.
* **Border Color** :\
  The border color to be set to the range of data. The default value is Not Set.
