Hi there,

I'm building a spreadsheet to help me track attendance.

I have each day of the month represented by a column, and names in rows.

I'd like each column to do a check to ensure I have no less than 6 null
fields.

ie:
1 2 3 4 5 .....
name1 x x
name2 x x
name3 x
name4 x
name5
name6
name7
name8

In day 1, there are 4 cells with null values, therefore that column should
be flagged somehow. Day 2 there are 6 nulls in that column, so no need for a
flag.

Any suggestions how I can accomplish this?

Thanks,