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.
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
You can use VBA for this.
1 Like