Multiple messageboxes and cell changes on different conditions

[JPCSydney]

Hi everyone,

I am relatively new to all of this and hope that someone is able to help me. It is a bit of a long pain but basically my boss wants to be able to receive warnings in an excel spreadsheet that the hours that casual employees work (in two different locations AAA and ZZZ) when they reach 80% and 95% of a target. The below is (I hope) a detailed explaination of the requirements but I also provided an attachment.

In a workbook there are two sheets called 'Planning' and 'DailyHrsFN'
In 'DailyHrsFN' tab users enter the number of hours each day in a fortnight period in each cell (H:U) which calculates the total in column "V" This feeds into tab 'Planning' colum R (Total worked hrs)

In 'Planning' tab
Cell B1 has a target hours of 988 - This relates to people in Location AAA
Cell B2 has a target hours of 1040 - This relates to people in location ZZZ

Cell Range R4:R13 is a record of total worked hours for people in location AAA - Cell range S4:S13 is just a % of R4:R13 by B1
Cell Range R14:R17 is a record of total worked hours for people in location ZZZ - Cell range S14:S17 is just a % of R14:R17 by B2


What the boss wants to occur is that when a person reaches 80% of their target hours (either 988 for AAA or 1040 for ZZZ) a popup message says "warning - 80% of target reached. Please contact xxx for approval" and the cell to change colour to orange. But still allows the user to enter and save the hours in 'DailyHrsFN' (which is where the user would be entering it from).

Additionally wants when a user enters a number in 'DailyHrsFN' that when it causes the cell in column S (in sheet 'Planning') reaches 95% of the target hours the cell goes red and another messagebox opens states that the person cannot be used any further - report to manager". The cell in 'DailyHrsFN' does not allow you to enter the hours.

The messages would only appear once upon confirmation of selecting an/the OK button.

My question is....Is this even remotely possible and if so, how? LOL

As always I appreciate the help.