Hey i am trying to make toning dynamically in my excel sheet with Uipath. But i can not understand how to reach the spesific and conditined cells. Can anyone help me out?

Help Activities
1

I am copying some data from another excel to my spesific excel. In my excel my datatable starts from D6 cell and i want to change some cells if they contain “OK” or another word. How can i reach each cell in excel? I am really confused

2

Hi @Enes_Arasan

For your task you need to write VBA code to perform the expected action.

Please share me the sample detail I will help in solution.

Thanks,
Purushotham

3

Hey, thanks for your answer but i remember that it can be done with for each row activity and coloring in excel. But i can not figure out how to use dynamic variable. For example, my table has a big header so the data starts from D6 and continues. I have to find the “OK” cells in all data table not just one spesific column. Can you help out?