If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

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 ...