Test Cell Type

This action tests the type of a cell or cells. The types are the data types of Excel: Text, Number, Logical (boolean), Blank, Error, Formula. These essentially corresponds to the Excel functions ISTEXT, ISNUMBER, etc. If more than one cell is selected by the Range Finder, then all the found cells must satisfy the condition of the test.

Properties

The Test Cell Type action is configured using the following properties:

Condition

This contains the condition that must hold:

Is Blank

This is true if and only if the found cells are blank. This corresponds to the Excel function ISBLANK.

Is Text

This is true if and only if the found cells all contains text. This corresponds to the Excel function ISTEXT.

Is Number

This is true if and only if the found cells all contains numbers. This corresponds to the Excel function ISNUMBER.

Is Logical

This is true if and only if the found cells all contains boolean. This corresponds to the Excel function ISLOGICAL.

Is Error

This is true if and only if the found cells all contains errors. This corresponds to the Excel function ISERROR.

Is Formula

This is true if and only if the found cells all contains formulas. This corresponds to the Excel function ISFORMULA.

If

Specifies the exact condition to test for, and thus enables inversion of the stated condition. The default is to test if the "Condition is Not Satisfied". If this is selected and the condition evaluates to false, execution will be affected as indicated by the Do property; however if the condition evaluates to true, execution will continue down the current branch. It is possible instead to test if the "Condition is Satisfied", which reverses the outcome.

Do

Determines what happens when the condition and the If property together indicate that execution should not continue down the current branch.

As Specified Under Error Handling

The Error Handling tab specifies in detail what to do.

Skip Following Steps

Execution down the current branch will stop.