How to select only the cells which is highlighted in a colour

Hi Everyone,

I need to extract the only data from the excel which is highlighted in green. Anyone suggest the solution. Rows were dynamic i need only the data which is highlighted in green.

The row index and column index were dynamic

Hi @Nagarajan_Krishnamoorthy ,
First Read the Data table and then You can use the Get Cell color Activity with for each row
you can use if condition and you can get the cell value


Hi @Rounak_Kumar1

I have hidden cells inbetween in this scenario we did not get the exact cell index

The expectation is to get the range with the range i need to use another read range and do the further process