Colorize Cells

Object for coloring the cells of the Excel worksheet.

Settings

Field	Descriptive
Title	Object Title
Select Main Object	Option to select an Excel sheet
Background	Option to select the cell's background color
Font	Option to select the font color of the cell
Select Range	Allows to enter a range of cells
Cells	Option to inform the cell to be colored

See how to set a range if the "Select Range" option is selected, by clicking HERE.

Example

To colorize the cells of an Excel spreadsheet, you must have a pre-existing file:

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 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. Finally, inform the desired cell.