Data Analyst

Greetings!

 

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.

 

Thanks!

By: Japneet

Leave a Reply

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