Room Booking using Excel

Hello,

I am using Excel to create a booking tool for a small bed and breakfast. 17 rooms max. 

When I book a guest for multiple days, let's say from Jan 1 to Jan 5, his/her last name will show in the calendar I created under each of those days. Questions:

1. Is there a formula or a way to look up all the cells with the same last name so that I can merge them and center them so that it only shows the last name once across the specified booked dates? It would look cleaner that way. 

2. Can I use Conditional Formatting to delimit each reservation with borders and colors?

3. Is it possible to split the Check-In-Date cell and the Check Out Date cell, in case I have a different guest checking in and another one checking out on the same date? In other words, if Guest A checks out on Jan 5 and Guest B checks in on Jan 5, Can I split the cell to show the names of the two guest on the same cell?

I would really appreciate any feedback.

Thanks!

M