Use the Get cell color action to get the color of the
background or text in a cell.
This action retrieves the color of a cell as RGB values. For example, if the
background or text in a cell is of red color, the value retrieved is 255,0,0.
Procedure
-
Double-click or drag the Get cell color action from
the Excel node in the Actions
palette.
-
Select the Background color option to get the background color of the cell or
the Text color option to get the color of the text.
-
Select the Active cell option to get the color from the current active cell or
the Specific cell option to get the color from the address of the cell you have specified.
-
Select a variable from the Assign the output to variable
list to assign the address of the empty cell to the variable you have selected
from the list.
-
Select the string variable you want to use to store the address of the
empty cell from the Assign the output to variable
list.
The
Control Room shows a descriptive
default variable name. If you create several output
variables, subsequent variable names are appended
with a -1, -2, -3, and so
on to avoid duplication.
-
Enter
the name of the session used to open the workbook
with the Open
action.
-
Click Save.