I am trying to create a macro in excel for the first time. I have 365 files (of similar format) and would like to count the number of cells if they have orange or dark blue background color.
I tried to import those files in SAS or R but it loses colors, which is the key to my functions.
I tried using cell color formula but it won;t work either.
Basically, I want to create a macro in excel for 365 files saying: sum the values if color in cells from columns D through H is either dark blue or orange.