I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in my ...

Such a thing could be easily done with a macro invoked from a button on your sheet, but it would be easier to answer your second question if you gave a bit more detail about what you're trying to do & ...