How to count grayed out lines in excel
 

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

How to count grayed out lines in excel
 

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

How to count grayed out lines in excel
 

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?

How to count grayed out lines in excel
 

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?