Extracting only the values which are in White cells(not the onces in yellow) and adding it

[kartik_sareen (KRK)]

Tricky: In this I just have to work with these 2 columns so starting with the column( Values Main), I have to add all the values but only which are in white and save it in a variable, second , taking the other column as Npv, I need to add all the values in white not in yellow and moreover in the column NPV, I need to add all the positive values together and all the negatives together. Need help…so tricky but a gud use case for all…

[AshwinS2 (Ashwin S)]

Hi @kartik_sareen
Use Excel application scope and use read range and use get cell color
based on color try to extract the color.name.ToString

so based on that you can retrieve the rows

Thanks
Ashwin S

[kartik_sareen (KRK)]

Could u please show with an example…that would be more helpful for everyone…Thank u Ashwin

[AshwinS2 (Ashwin S)]

Hi @kartik_sareen

Check this

SOLVED - Get Cell Color Function

Hello Searl, Can you please share your sample workflow. Because I want my flow to detect color of a box and if color match with required color then it should return the text or name of the box. For example: [image] Like if color is red then flow should its name ‘GLD_APU2’. Thanks in advance

Thanks
Ashwin S