Filter cell colour

[Mark_Rajkumar (Mar)]

I am trying to filter a number of colour cells and eliminate those with out colour. How do i achieve it?

[Garret]

You could create a vba macro and run it from in process:

excel - VBA code to delete cells that contain a certain fill color? - Stack Overflow

[fernando_zuluaga]

Here is an idea

How to check if a column of datatable(Excel) contains a value and highlight it?

hey i made it for you [image] check the xaml test.xaml (13.1 KB) hope it help you regards!

basically instead check that the cell has any value, just check if its empty and instead fill with colour just delete it

if any questions i would help you

Regards

[Gokul_Jayakumar (Gokul Jai)]

Hello @Mark_Rajkumar
Refer to this thread, you may get some idea.

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…