Get cell color action - Use the Get cell color action in the Excel advanced package of Automation 360 to retrieve the background or text color of a cell as RGB (Red, Green, Blue) values. For example, red is 255,0,0. Gets the color of the background or text in a cell.

Automation 360

Use the Get cell color action in the Excel advanced package of Automation 360 to retrieve the background or text color of a cell as RGB (Red, Green, Blue) values. For example, red is 255,0,0.

Before you begin

Ensure that an Excel session is active and a spreadsheet is open.

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 to get the color of the text.
  3. Select the Active cell option to retrieve the color from the current active cell, or select Specific cell to specify a cell by address.
  4. If you selected Specific cell, enter the cell address (for example, A1) in the cell address field.
  5. Select a variable from the Assign the output to variable list to store the retrieved RGB color value.
    The 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 .
  7. Select Save.