How to check if a row contains color?


I have a datatable from an excel and I only need to do the process in the rows which have no color in any cell.

Could you help me, please, with the condition I have to write in the if activity?

Thank you very much in advance. :slight_smile:



Any playing with color has to happen in Excel, before the datatable is created. By default, datatable can not store any color/formatting information.

To check color in Excel, you can use: “Get Cell Color” or “Get Range Color” activities

Loop through each cell row wise, OR consider one row as a range and check color, if no color, add row to datatable.