Replace rows and leave color of the celsl remaining

Can i transfer row from one sheet to another with color of cell and other properties?
I grab rows from this table,relying on the value in column A

And I want to paste row to this table with red color

So, particularly in this case it would paste the 1st row and the 2nd. because values match.

Appreciate that

1 Like

Hi @kuzinyd

Use Read range of excel and sheet and paste into another excel by using write range activity

use set range color activity and mention the range as A1:+Datatable.rows.count.ToString

Ashwin S

Hi, @AshwinS2
As per my knowledge output of read range activity is DataTable means that properties like color are not being saved when using this activity. I don’t wan’t to loose data in the final excel sheet, just to be able to replace matching values with color remaining.

Fine No worries
Kindly have a view on this thread and let know for any queries or clarification

Cheers @kuzinyd

1 Like