Counting Highlighted Cells- Fastest way?

Giganews Newsgroups
Subject: Counting Highlighted Cells- Fastest way?
Posted by:  tjohns…
Date: Mon, 28 Jul 2008

Currently I am working on web reports in which I have highlighted
cells in several different worksheets.

I then have a summary page which counts the Sum of Column J,
COUNTA(J2:J1000) which counts the number of data entries in the range,
and then i have to manually filter column J by highlighted
color(yellow).  Not all rows have a highlighted column and so I
currently just Filter by Cell Color and is the Count function at the
bottom of the screen; however this is time consuming and  I am trying
to automate this report as much as I can, but I am stuck on this.

I am using Excel 2007 and have some experience with VBA, but cannot
seem to come up with a way to automatically count(through function or
macro) populate my summary page.

If anyone has any suggestions or ideas, I would greatly appreciate it.