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

Help with Volunteer Attendance Sheet
 

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" wrote in message
...
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