Colored font count (web)

[Cl2130]

I need to be able to count cells that are a specific color. I’ve read I can do this with vba but the issue is I need it to work on the web version.

I have about 80 workbooks, there are blank cells that are preset to red font, so when data is entered the team see’s the red data and enters it into a data base and then changes the font to black.

I wanted to have a count of red cells per workbook and have that info go on a master sheet so we know to open only workbooks that have red font, so we don’t have to open each one everyday.

Any ideas would be appreciated.

 

[Micron]

Did you consider checking the file's last modified date against some other date? Not fool proof but I imagine people are not opening these files and saving without making any changes. I just tested and doing that does alter the modified date even though I didn't change anything.

Another option could be to use a programming language that is compatible with web based files:

Is there a way to use macros in Excel online version(office 365)?

I worked on excel macros for widows application to load data. I have created the add-in but now I have to use the same add-in in excel online version which is web based or is there any way to impor...

stackoverflow.com