Help with Volunteer Attendance Sheet

Hi,

First off thanks so much in advance for your responses.

I have attached an Excel Spreadsheet.

This spreadsheet will be keeping track of attendance of volunteers that show
up weekly. We want to call volunteers who have not shown up for three weeks
consecutively.

We would mark in a cell an X if they worked the week indicated by the top fo
the column. We have a checksum to indicate the week we are in. We will
check that off each week...unles we can automate it.

If there are three blank cells in row for the previous three weeks
(indicating abscence) prior to the week we are currently in, then their
phone number would flash red (or just be red) This will alert us to call
them and invite them back. If we put in a C for the current week indicating
we called them then the phone number would go back to black.

How would I go about this?

Thanks,

Tim

Tim,

select B5 down, and then in conditional formatting, use this formula

=COUNTA(OFFSET($A5,0,MATCH(TODAY()+CHOOSE(WEEKDAY(TODAY()),6,5,4,3,2,1,0),$2
:$2,0)-4,1,3))=0

I would use a pattern of red, not flashing text.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tim" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> First off thanks so much in advance for your responses.
>
> I have attached an Excel Spreadsheet.
>
> This spreadsheet will be keeping track of attendance of volunteers that
show
> up weekly. We want to call volunteers who have not shown up for three
weeks
> consecutively.
>
> We would mark in a cell an X if they worked the week indicated by the top
fo
> the column. We have a checksum to indicate the week we are in. We will
> check that off each week...unles we can automate it.
>
> If there are three blank cells in row for the previous three weeks
> (indicating abscence) prior to the week we are currently in, then their
> phone number would flash red (or just be red) This will alert us to call
> them and invite them back. If we put in a C for the current week
indicating
> we called them then the phone number would go back to black.
>
> How would I go about this?
>
> Thanks,
>
> Tim
>
>
>