Tracking overtime signups in 1/2 hour increments by day

S

Stephanie

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?
 
D

Dave O

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.
 
Top