Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Excel Color Cells

If possible, it would be very nice with the possibility to color cells directly through a ProcessRobot/WinAutomation actions.

Right now it takes several UI actions to change the color (for example: red for a bad value, and green for a good value) and this can take a long time in a spreadsheet with hundreds of rows.

I have encountered these process steps in several projects now. People generally like indicator colors in their end product Excel Sheets.

1 person likes this idea


Hello Henrik,

While the Excel file is open, feel free to use the "Run VBScript" Action and run the following code:

Set objExcel = GetObject("%Excel%").Application
objExcel.Application.Visible = True

Set objSheet = objExcel.Sheets("%Worksheet%")

objSheet.Range("A1:A1").Cells.Interior.ColorIndex = 40

%Excel% is the Excel file path

%Worksheet% is the name of the worksheet

ColorIndex is the color number. Feel free to check the available numbers on the internet.

1 person likes this

Thanks, that's great info! 


You are welcome Henrik!

Login or Signup to post a comment