Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAGoogle Sheets

Style cells

Style cells

Sets the background/text color, bold, italic, alignment and border of a cell range.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Sheet (tab) name or ID​

Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

Set a background color​

Option to select Yes or No to apply a background color to the cell range. When enabled, enter the color as its red, green and blue components, each from 0 to 1 (e.g. white is 1, 1, 1).

Set a text color​

Option to select Yes or No to apply a color to the text of the cell range. When enabled, enter the color as its red, green and blue components, each from 0 to 1.

Bold​

Select Yes to apply bold or No to remove it from the range's text. Default: No.

Italic​

Select Yes to apply italic or No to remove it from the range's text. Default: No.

Font size​

Enter the font size to apply to the range's text (optional).

Horizontal alignment​

Select the horizontal alignment of the cell content: Left, Center or Right. Leave it blank to keep the current alignment.

Vertical alignment​

Select the vertical alignment of the cell content: Top, Middle or Bottom. Leave it blank to keep the current alignment.

Set a border​

Option to select Yes or No to apply a border to every cell of the range (each cell gets a border on all four sides).

Border style​

Select the border style: SOLID, SOLID_MEDIUM, SOLID_THICK, DASHED, DOTTED or DOUBLE. When not given, the default SOLID is used.

Border color​

Option to select Yes or No to set a color for the border. When enabled, enter the color as its red, green and blue components, each from 0 to 1.

Advanced options​

Starting row​

Enter the number of the first row of the range (optional).

Ending row​

Enter the number of the last row of the range (optional, included in the range).

Starting column​

Enter the number of the first column of the range (optional, 1 matches column A).

Ending column​

Enter the number of the last column of the range (optional, included in the range).

Returns​

This action has no returns.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Sheet (tab) name or ID fields are required.
  • Bold and Italic are always applied to the range: with No (the default), the robot removes any bold and italic the cells already had, even when the action only changes something else, such as the background color. To keep that formatting, select Yes in the matching options.
  • When Starting row, Ending row, Starting column and Ending column are not given, the style is applied to the whole tab.
  • If the Ending row is lower than the Starting row, or the Ending column is lower than the Starting column, the robot stops the run with an error.
  • If a border is set with no specific style, the default SOLID is used.