Select Range

Object to select a range of cells to be colored.

Settings

Field	Descriptive
Title	Object Title
Select Main Object	Option to select an Excel sheet
Background	Opção para selecionar a cor de fundo da célula - Option to select the cell's background color
Font	Option to select the cell's font color
Select Range	Allows you to enter a range of cells
Starting Column	Initial column of the cell range that will be colored
Final Column	Final column of the cell range that will be colored. If none is set, the last column of the spreadsheet will be considered as the final one
Starting Row	Initial row of the cell range that will be colored
Final Row	Final row of the cell range that will be colored. If none is set, the last row of the spreadsheet will be considered as the final one

Example

To colorize the cells of an Excel spreadsheet, you can select a range:

1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.

• First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the "Select Sheet" object from the "Excel" menu, select the main object defined when opening the Excel file and then define the name of the sheet you wish to select.

3 - Then you must select the "Colorize Cells" object in the "Excel" menu, select the main object, select the color for the cell's background and the color of the font to be used and click on the "Select Range" option. Finally, inform the columns and rows corresponding to the cells you wish to colorize.