Skip to main content

Set Range Color

UiPath.Excel.Activities.ExcelSetRangeColor

Changes the color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope or Use Excel File activities.

Properties​

Input​

  • Color - The extracted color stored as a System.Drawing.Color variable.
  • Range - The cell or cell range whose color is to be changed. For example, you can use either "A1:C1" or "B4". Only strings and string variables are supported. Strings have to be placed between quotation marks.
  • SheetName - The name of the sheet that contains the cells to be colored. The default input of this field is "Sheet1." Only string variables and strings are supported. Strings have to be placed between quotation marks.

Common​

  • DisplayName - The display name of the activity.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of how to use the Set Range Color activity​

To exemplify how to use this activity, we have built an automation project which analyzes the results of a file and rearranges them in the correct order. You can download the example from here.