Hi there,

I am trying to track the progress of a project where we have over 1000
line items to review. We would gray out the line that has been
completed. Is there a function where excel can count the number of
lines grayed out so that I don't have to manually count since they are
not being grayed out in order. Would appreciate your help, thanks!

Shirley

If using 2003 version select a column and EditFindFormat.

Select the gray pattern and Find All.

In the 'Found" dialog box hit SHIFT + down arrow.

Click on Status bar and select "Count"


Gord Dibben MS Excel MVP

On Fri, 28 Mar 2008 10:32:48 -0700 (PDT), sfnbgirl
wrote:

Hi there,

I am trying to track the progress of a project where we have over 1000
line items to review. We would gray out the line that has been
completed. Is there a function where excel can count the number of
lines grayed out so that I don't have to manually count since they are
not being grayed out in order. Would appreciate your help, thanks!

Shirley

Thanks so much Gord. I am now able to count the grayed out lines, but
is there a macro I can put in place where it will count the lines
automatically and subtract that from the total number of lines?

You can use Chip Pearson's CountByColor function.

http://www.cpearson.com/excel/colors.aspx


Gord

On Fri, 28 Mar 2008 12:17:46 -0700 (PDT), sfnbgirl
wrote:

Thanks so much Gord. I am now able to count the grayed out lines, but
is there a macro I can put in place where it will count the lines
automatically and subtract that from the total number of lines?