What formula do you have in N44?

How is the return of your Countif formula deducted?

The Countif() accumulates the "sick time" for a particular time period, but
you haven't told us what formulas you have in other cells that perform
calculations with *that* Countif() return.

It's *those* formulas that could be put in a validation setting that can,
for example, turn red when they reach a pre-arranged criteria.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Frank" wrote in message
...
Dave,

I need to stop the formula from deducting 8 hours from the sick time total
if the person does not have enough sick time balance. I would like to
triger
a message stating that the person does not have enough sick time to
complete.

"Dave O" wrote:

Need help interpreting your post: you need to add sick time if the
total cell is less than one?