Tracking overtime signups in 1/2 hour increments by day
 

I need to set up a spreadsheet which allows the user to check off the fact
the someone has signed up for a overtime slot on Monday at 8:00 am but
allows the remaining slots to display. I am considering a spread sheet that
looks as follows:

8:00 8:00 (indicating 2 slots )
Monday
Tuesday

or rather
8:00
Monday 2 slots But how do you subtract the number who has taken the .

This spreadsheet will go to a user who is not friendly with excel. So it
has to be something easy to use.

How would conditional formatting be used to accept an "x" as a value? If
this is too much for the forum. Is their a information somewhere on
spreadsheet design?
--
Stephanie

Tracking overtime signups in 1/2 hour increments by day
 

In the Conditional Formatting setup for the cell in question (I used A1
for this example), set the dropdown to "Formula Is" and enter this
formula as the condition:
=A1="x"

Then apply the desired format. If you don't mind an outside opinion, I
prefer your first example above, which shows the 8:00 slot twice. That
seems more intuitive, and may be helpful for your non-Excel friendly
user.