Conditional Formatting
 

I have a calendar spreadsheet which I created myself which we use to enter
for employees days off and partial days off as well as a column to list
anyone waiting that would like to be off that day in case someone cancels the
request. We are only allowed a certain number of people in each unit off per
day. I wanted to know if anyone could tell me how I could get Excel to place
a little red light or certain verbiage once all of the slots are filled
letting the manager know that the day is closed for requests. Thank you!