Dates and conditional formatting

[darkan9el]

I have excel 2010 and I'm making a spreadsheet for two holiday homes, each month will have its own sheet, I need to make the balance hightlighted 6 weeks before the guests arrival date, can this been done?

Also is it possible to display a monthly calendar on the spreadsheet to show what dates are booked?

Am I making this too complicated?

I'm bit of an excel noob so simple is good lol

[Unca Wook]

Hi darkan9el;
Are you looking for something akin to what a B&B would use to track their bookings? If so I may have something of interest to you that I made for a B&B.
That might solve the calendar portion of your problem

[darkan9el]

Hi Unca Wook, that would be great, might help me learn a bit too.

[Blake 7]

is this what you are after