have a workbook of which I check every month for breaks in continuity on
a variety of machines. What im trying to do is see the breaks in
continuity when dates are missing.

I.E say I have a workbook which has start dates.end dates and machine
numbers

Machine 1 Start date= 01/03/2006 end date = 07/03/06 then on the next
entry Start 08/03 end 16/03. Obviously there no break there so that
fine.
Machine 2 Start 01/03 end 07/03 start 25/03 end 31/03. Obviously there
a break there and I need to be able to have that highlighted. I just
need it to highlight when there is a break in dates and not in between
2 dates.

There are about 40 machines which all have there own number. When their
input they are not in any order cos there input every time there
emptied. I only need to check the contunity monthly so if to make it
easier they can be sorted into machine no before checking for breaks.

Can anyone help?


--
tweacle361
------------------------------------------------------------------------
tweacle361's Profile: http://www.excelforum.com/member.php...o&userid=32202
View this thread: http://www.excelforum.com/showthread...hreadid=531321