Hi Guys!
I really need your help on this one! This is the last step of my project, and I'm not able to figure out how to do this. So some values are entered in column D and E. D is the "from location" and E is the "to location", which depicts that everything between these 2 locations (in this case 10-45, including them) is occupied. This is unique for every row. So whenever a user enters a value in A3 in between 10-45, eg 12,30,40 (including them), an error message should pop up - saying this location is occupied.
Total locations are from 1-350
Also, one more condition here is that this message should occur if the cell in the same row under the progress column is empty. If its filled with "In Progress" the message shouldn't pop up.
I really need your help on this one! This is the last step of my project, and I'm not able to figure out how to do this. So some values are entered in column D and E. D is the "from location" and E is the "to location", which depicts that everything between these 2 locations (in this case 10-45, including them) is occupied. This is unique for every row. So whenever a user enters a value in A3 in between 10-45, eg 12,30,40 (including them), an error message should pop up - saying this location is occupied.
Total locations are from 1-350
Also, one more condition here is that this message should occur if the cell in the same row under the progress column is empty. If its filled with "In Progress" the message shouldn't pop up.