Is it possible to filter an excel column by color?

[md.muhit]

I was wondering Is it’s possible to filter an excel based on color. I have data in excel I just need to filter by the specific color. Without using VBA is it possible? Thanks in Advance.

[Yoichi]

Hi,

The following post may help you.

Excel FILTER By Colour

Dear Nidhi, 1.Use Excel App scope to read the data,then loop through each row of the datatable and get the color of the cell of column RRN lets say “A”(col in excel) using Get Cell color activity “A”+(intIndex+2).ToString Set the Output index =intIndex to get the index of the row when u loop thru the datatable. intIndex+2 - 0 indexed and first row in excel is header so we add 2 2.Use if condition to check the color: colCell=Color.Yellow If condition satisfied then add the value to a new d…

Regards,