I have a calendar in Excel, and we can't allow more than a certain amount of
staff off during a given amount of time. I have a few cells that comprise a
single day, and listing staff names on each one of those lines. I'm trying
to figure out a conditional formula that will shade the entire "day" a
certain color if all of the cells contain value.

For example: 4/1/09 is cells C11:C15. Using the formula below, if any
value is entered on any one of those cells, it highlights the entire group of
the cells with the color specified.

=COUNTA($C$11:$C$15)

Can anybody direct me as to how I can get it so that ALL of the cells must
contain a value, for any of them to be shaded red? Meaning, something MUST
be entered in C11, to C15, then all of the cells will then change in color?

Thanks!