Tag Archives: macro

0-count-number-of-formatted-colored-cells-google-sheets

Dear Analyst #115: How to count the number of colored cells or formatted cells in Google Sheets

Counting the number of colored cells or formatted cells in Google Sheets or Excel seems like it should be a basic operation. Unfortunately after much Googling, it doesn’t seem as easy as it looks. I came across this Mr. Excel forum thread where someone asks how to count the number of rows where there is […]

Dear Analyst #53: Making your Google Sheets do more for you with Google Apps Script and how to become more data-driven

When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more, I found that Google Apps Script offers similar functionality to extend what […]