Filter Rows Based on Color

[Anil_G (Anil Gorthi)]

@shreyash_shirbhate

Try recording a macro and check ehat is the exact rbg value…looks the cell is having a different set

Cheers

[shreyash_shirbhate]

@Anil_G
How to do this? Like recording the micro?

[Anil_G (Anil Gorthi)]

@shreyash_shirbhate

Just go to developer tab in the excel tabs…if you dont see it then go to excel options and select developer tab then you would see in ribbon…

On the developer tab you would see record macro and from then on till you click stop everythign gets recorded …so during that time…click on filter …and filter on color and click on the color you are having trouble on…

And then click visual basic to open recorded macro where rgb values would be visible

Cheers

[shreyash_shirbhate]

Hi @Anil_G,

Filtration part is running fine. I have save the micro in excel micro and running it with execute micro activity. But the problem is after filtering when I am reading the data using read range it is taking all of data and not the filtered one.

I have checked the filtration thing carefully and there seems to be no issue. How to read the filtered data from the the excel sheet?

[Anil_G (Anil Gorthi)]

@shreyash_shirbhate

In read range use visible rows option…and use modern excel activities

cheers

[shreyash_shirbhate]

Hi @Anil_G,

For that I will need to completely switch my entire project to modern design experience which I don’t want to do it. My existing activities will not work in this scenario and I can’t afford to loose them.

Can you please suggest me any different approach?

[Anil_G (Anil Gorthi)]

@shreyash_shirbhate

You need not switch…only for this click on filter in activities and then select modern and can use

or can try with this property

cheers

[shreyash_shirbhate]

@Anil_G ,

Not working with this.

Do you know how to provide range in below activity? I tried giving double quotes but it is not working.

Thanks!

[shreyash_shirbhate]

@Anil_G,

Ignore above reply, I think I got what you are trying to say. Let me try and get back.

[shreyash_shirbhate]

Hi @Anil_G,

I tried but I am not able to see Use filter property in my activity, please check the below screenshot.

[Anil_G (Anil Gorthi)]

@shreyash_shirbhate

I believe you are usinn workbook read range …can you check with excel read range please

Cheers

[shreyash_shirbhate]

Hi @Anil_G ,

Thank you so much for helping me out. It worked perfectly fine.

Thanks,
Shreyash