Vacation Visualization

I have a simple workbook consisting of a sheet for vacation date entry and a second sheet which will provide a visual representation of the vacation period booked.

How do I take the dates on one sheet and create individual cell formatting ie shaded red (or some other entry ie "V") on the second sheet for the date ranges specified?

Thanks for any suggestions.