Set Range Color

This action is used to set the foreground and background color for a specified range.



  • Excel Document: File name for the target Excel document.

  • WorkSheet: The target worksheet name.

  • Cell Range: The target range.

  • Foreground: The foreground color.

  • Background: The background color.

Both foreground and background colors need to be a System.Drawing.Color object.


  • Display Name: action display name in your implementation project

  • Wait Before: number milliseconds robot to wait before executing the action.

  • Wait After: number milliseconds robot to wait until moving to the next action.

  • Abort on Error: True/False

  • Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

  • Color the headers of an excel file for a better identification.

  • Color the columns or rows of an excel file for a better differentiation.

  • Color specific cells of an excel file in order to highlight important data.

Examples of Using Set Range Color


Watch the robot in action:

You can check and download the example from here:

Last updated