Hi!
I am working on a spreadsheet for preschool registration.
In the 1's classroom, we can have a maximum of 9 children on any given day. Children are offered either 2 days/week, 3 days/week, or 5 days/week.
What I would like to do is format the 2 days/week and 3 days/week columns so that you cannot enter a "X" if you have more than 2 of either 2 day or 3 day without the corresponding 2 day or 3 day slot filled. (I do not want to have all 2 day children and no 3 day children. I only want to allow for 2 slots without the other days filled.)
In addition to this, if possible, I would like to have my total working so that we do not exceed 9 children on any given set of days.
I have the formula =IF(OR(B2=C2,B2<>C2+1,B2=C2-1)) in data validation and in Conditional Formats I have the cells green if they are not empty. I also have a total at the bottom of B and C that uses the rule =COUNTIF(B2:B15,"X") to format the total X's.
My totals are 0 right now. I am getting a rule violation if I try to add any X's in B or C. What am I doing wrong?
Thanks for any help! I really don't know what I'm doing and have spend hours and hours just getting to here!
Paige
Bookmarks