For first use conditional formatting.

For pop up you can use data validation.

Let me know if you need detailed instructions.

"delete automatically" wrote:

Make a cell font red if number is greater than 200 and have a message pop up
saying (you have exceeded the number of hours allowed).