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