Using Get cell color action

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

  1. Double-click or drag the Get cell color action from the Excel node in the Actions palette.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. Enter the name of the session used to open the workbook with the Open action.
  7. Click Save.