How to count grayed out lines in excel

[sfnbgirl]

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

 

[Gord Dibben]

If using 2003 version select a column and Edit>Find>Format.

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

 

[sfnbgirl]

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?

 

[Gord Dibben]

You can use Chip Pearson's CountByColor function.

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


Gord