Conditional Formatting

Object for formatting according to the informed conditions.

Settings

Field	Descriptive
Title	Object Title
Select Main Object	Option to select the Excel sheet
Background	Option to select the cell' background color
Font	Option to select the cell's font color
Select Range	Allows you to enter a range of cells
Cells	Option to inform the cells
Condition	Option to select the formatting condition
Operator	Option to select the formatting operator
Content	Option to enter the content for formatting
Stop if True	Option to stop execution when the condition is true

Example

To format cells according to defined conditions you need to follow a few steps:

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 Spreadsheet" object from the "Excel" menu, select the main object defined when opening Excel, and define the name of the sheet you wish to select.

3 - Then select the "Conditional Formatting" object in the "Excel" menu, select the main object, select the color for the cell background and the color of the font to be used. Then inform the cells you wish to format.

• If you select the "Select Range" option, inform the corresponding columns and rows for formatting.

4 - Finally, select the condition, the operator and enter the content for the formatting.

• If the "Stop if True" option is selected, execution will stop when the condition is true