I need a UiPath that will copy only cells with blue background color

how can I copy the value of cells with blue color only put it on a new Excel sheet and copy the header and equivalent row of that colored cell.

@Ferdz_Yuson

Welcome to the community

you can use loop on the first excel and then use get cell color activity to check the color and if matchign then copy using copy paste activity else dont copy

cheers

1 Like

@Ferdz_Yuson

You can use VBA for this.

1 Like