EXCEL must sum the colored cell in excel file

[flashdrive07 (Pete)]

I’m using StudioX please help.

automation process must sum the colored cells in excel sheet.
for example the column is fill color red and must sum all the fill color red in the sheet…

I have trouble solving this one … your solution is a big help to me…

[Mohammad_Irfan (Mo Irfan)]

@flashdrive07 Hi, you want the sum of the colored cells?
you can either use the column name if it is for the whole column
or you can use macros.

[flashdrive07 (Pete)]

ooohh i see, so studiox can’t automatically sum the colored cells ?

[fernando_zuluaga]

Hi @flashdrive07

Give a try with this custom activity

Calculate Sum of Colored Cells in Excel Sheet - RPA Component | UiPath...

Another solutions:

Excel Filtering Column by Color and write Sum of filtered data

Hi @Shubhankar_Gadekar Not sure whether there is a direct way to filter by color. But you can use the below approach as well. You can use this activity to find the color of the cell. You can use it within a loop that runs for the range you specify. Based on the color add another column in the excel as a flag that represents the yellow color. Then read the entire excel using read range and filter the records based on the color flag we just added Let know whether it helps…

Regards

[Anas-p-v]

You can loop through the columns, there is an activity called “Get Cell Color”, by which you can get the color of the current cell, and if it matches to the color specified, you can take the cell value to sum up. Attaching a sample screenshot below.

[flashdrive07 (Pete)]

Hi thanks by this image i already got it… thanks

then my next question is . is it possible to set the font color of specific column using its header name ?