Data Analyst



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.



By: Japneet

One thought on “Data Analyst

Leave a Reply

Your email address will not be published. Required fields are marked *