Unable to Copy the color of filter cells

I’m trying to copy the color of excel rows after filtering the data but it did not color the rows.so how to do it?
my data is coming like this-

output should be like this-

how to resolve this issue?


Hi @Cuberoot ,
Activity can copy data only, not copy format file?
You can create file template with format to write data
or use VBA to create format to file

I cannot create a template because the file has a date column.

I see, but we can get only data to before date only

Thanks for your reply.

above green color highlighted is current date

Do you understand my way
My way is don’t care other
we can get only range

OK.Could you pls tell me how to color it?

Have you try set range color?

no, i don’t do it…
data.xlsx (13.0 KB)

Can you share your input file and expect output?
I will test for you

input file is in Sheet1 and output file is in Sheet2.



Please try with copy paste range activity


Hi @Cuberoot

Please find the below xaml for your reference

BlankProcess9.zip (50.8 KB)

Hope this helps!!

it paste whole data but I want some rows


Then give the range in the copy paste range activity…

You can give the ramge you wnat to copy as well…example below



if i want to filter ID=688.then how how to copy the color of whole row?
Thnaks in advance


After filter…use a find /replace activity and search for 688…which will give you the cell number like A6 or so which is stored in variable str…then use "A" + System.Text.RegularExpressions.Regex.Match(str,"\d+").Value + ":G" + System.Text.RegularExpressions.Regex.Match(str,"\d+").Value

Here change A and G as you need…row number will come from find /replace

Hope this helps


after filtering activity it shows dropdown option in every column can we remove it-



Use filter activity again and select remove filters…it would remove that


no it didnot remove it.Could you pls do it?
data.xlsx (13.1 KB)