I have the incredibly tedious task of trawling through peoples diaries
(Lotus Notes) for time slots when people are either free or busy (for
a potential meeting)

e.g.

Column 1 9am - 10am
Column 2 10am-11pm

(.. and so on until 4pm-5pm)


The rows are the individual peoples names


e.g.
Row 1 Adam
Row 2 Brian
Row 3 Chris

(and so on.. depending on how many people there are)


What I do is simply shade/fill cells when people are free in GREEN
....and when one person is busy I shade them GREEN

(a bit tedious itself as I have to select each cell, then choose the
fill colour)




After I have put in all the data, I scan along and look for columns
that are entirely green (as this would mean everyone is available at
that specific time). Is there anyway to get excel to automatically do
this? (when there are 30 or 40 people involved it becomes tedious
looking through - with a few people it's simple)


(by the way I cannot use Lotus Notes' built in calendar planning
feature as not ALL people's calendars are electronic. And I need to
present the grid to my boss - for example to prove there really are no
free time slots on any given morning/afternoon - that I really have
bothered to search through everyone's diaries)