Set Range Color

Sets the background color of a given range.

This activity sets the background color of a user-specified range in the given workbook sheet using the Microsoft Graph Update range format API.

Input

• Connection Id: GraphServiceClient Variable Required Specifies the office 365 connection id.

• Sheet Name: String Argument Required Specifies the sheet name in which a range of color is to be created.

• Range: String Argument Specifies the range in which new background color is to be set. Input the cell range in A1-style notation like "A1:A5".

• Workbook: Object Argument Required Specifies the DriveItem of the Excel workbook in which a specific range color is to be set. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array. For example : Results[1].

• Color: String Argument Required Specifies the background color for the specified range which can be the name of the color (ex:- "AliceBlue") or the Hex Code that represent the color (ex:- "#cf0000").