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