If the number below is the weekend of the previous month, I want to right-click the upper cell and add the color.
I want to know how to find the previous month’s weekend and how to click up.
When asked to click on the upper K2 cell, click on the K2 cell with the number.
Please tell me how to do it
Hi @wjdehdnr456
Right click on the specified column or cell that has to be done with the Ui automation only.
Instead of clicking operation you can use the excel activities to set the color to the required columns or cells.
In the excel activities, there is a activity called Set Range Color activity which helps to fill the color in the required range in excel.
Check the below image for better understanding,
Hope it helps!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.