Highlighting several columns in Excel


#1

Hi all,
I am using excel via the window, and I need to highlight 3 columns in the excel for conditional formatting.
Is there a way to record this action in RPA? Right now, I highlighted it manually before running the script. Thanks.


#2

Sure, you can record it - we have object recording starting from version 2.0.
And you can edit the recorded actions using the Capture from screen option and Inspector.


#3

Thanks,will explore.
I also tried using mouse click now to highlight the columns and always run into mouse click error.
It would be great if able to use the method you mentioned :smile: