From: Ross on
I am using the 2009 employee attendance tracker from office online... of
course i have made some changes to suit my needs. This is the link to it for
better understanding:

http://office.microsoft.com/en-us/templates/TC103347271033.aspx?pid=CT101436151033

Now under the various categories like disability, essential, holiday etc, I
want to have a cap on them... For instance i can use the disability option
say only 7 times. After having it used for 7 times, if i try selecting that
option again, i want an error or a message to flash in front of my eyes that
i cant use the disability option any more as i have reached the max no. of
times allowed.

I already have a seperate column wherein the max leaves allowed under each
category is mentioned.
From: Worn Out Retread on


"Ross" <Ross(a)discussions.microsoft.com> wrote in message
news:D40C25BA-9719-4513-9C6C-742E7D5592F0(a)microsoft.com...
> I am using the 2009 employee attendance tracker from office online... of
> course i have made some changes to suit my needs. This is the link to it
> for
> better understanding:
>
> http://office.microsoft.com/en-us/templates/TC103347271033.aspx?pid=CT101436151033
>
> Now under the various categories like disability, essential, holiday etc,
> I
> want to have a cap on them... For instance i can use the disability option
> say only 7 times. After having it used for 7 times, if i try selecting
> that
> option again, i want an error or a message to flash in front of my eyes
> that
> i cant use the disability option any more as i have reached the max no. of
> times allowed.
>
> I already have a seperate column wherein the max leaves allowed under each
> category is mentioned.

You could use Conditional Formatting to tell you when you have reached the
max for each category.