Double booking problem for Reservation Program

alex410

New Member
Joined
Jan 5, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello everyone,
I am looking for some help with the attached MS Excel Spreadsheet (2nd and 3rd picture/attachment). This is a Conference Room Reservation program on MS Excel.

The formula detects double bookings and highlight them in yellow but I would like it show an error message when there is a double booking meaning the cell value is < 0.
Here is the formula used: =1-SUMPRODUCT(('Conference Room Reservation'!$C$2:$C$1000<=F$6)*('Conference Room Reservation'!$B$2:$B$1000=$I$3)*('Conference Room Reservation'!$D$2:$D$1000>=F$6)*('Conference Room Reservation'!$E$2:$E$1000=$C7))

If there is a double booking the prompt should tell the user that a double booking exists and to book at a different time for that room.
I would also like the booking labels to have the user's name.
Please see the first picture below/attached where I put in how the outcome should look.

Can you please help with this. Thank you so much.
-
Alex



Ideal outcome.JPG

Excel File 1.JPG
Excel File 2.JPG



=1-SUMPRODUCT(('Conference Room Reservation'!$C$2:$C$1000<=F$6)*('Conference Room Reservation'!$B$2:$B$1000=$I$3)*('Conference Room Reservation'!$D$2:$D$1000>=F$6)*('Conference Room Reservation'!$E$2:$E$1000=$C7))
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help needed with Conference Room Reservation (double booking)
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
I solved this issue on my own so this inquiry is no longer required. Thanks.
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top