How to count grayed out lines in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sfnbgirl - 28 Mar 2008 18:32 GMT

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

Reply to this Message

Gord Dibben - 28 Mar 2008 19:16 GMT

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

>Hi there,
>
[quoted text clipped - 5 lines]
>
>Shirley

Reply to this Message

sfnbgirl - 28 Mar 2008 20:17 GMT

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?

Reply to this Message

Gord Dibben - 28 Mar 2008 21:06 GMT

You can use Chip Pearson's CountByColor function.

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

Gord

>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?

Reply to this Message