church visitation
 

Hi.

We are small church about 250 members.
We do visit our church members and we record them in an Excel spreadsheet.

Column A - 1st name, column B - last name
and from column d up to column Y, we input the date of when we visited each
members for example in column C:3 across their name.

Our pastor is requesting me to revise the worksheet to allow him to see at a
glance those members that have not yet been visited, so visitaion may be
scheduled.

I have do conditional formatting by adding counting the no of blanks from
Column d to column BZ (which is 22) and highligting the member's name in
column A, formula =(Z2:Z200=22). That means those with highlight have not
been visited.

This seems so crude. Is there a better way? Appreciate your help and advice.