52 week report & conditional formatting

[adambedford]

I have a villa booking database and am trying to produce a report to document what villas where rented when.

How would I go about producing a report that has 52 squares across (one for each week of the year) and that if the property was booked that week it gets filled a certain colour and if it was free, it gets filled another colour.

Is this possible? It's just an idea and if anyone has a better idea how to do it I would be very appreciative!

Thanks