I have over 1000 case numbers on column B. Within columns M,N,Q,R,U,V,Y and Z I have the date and time values - ie. 2/12/2007 10:38:00 PM. For all the cells in the above columns (M-Z), how can I select all the case numbers which have only the following time "12:00:00 AM"? Case numbers that meet the above criteria should be highlighted to separate them with the other ones. Any ideas? Thx.