comparing adjacent cells

  • Thread starter Thread starter Mike Tindall
  • Start date Start date
M

Mike Tindall

I am working in a sheet with a column of dates and times, for example
(02-SEP/01:30Z) . I need a macro or other function that can automattically
compare adjacent cells above and below and flag them in some way I.E> change
font color. This is a sheet to deconflict events that fall within an hour of
each other.

I'm not even sure which function to star up with.

Any Ideas out there.

Mike
 
Have you entered the date+time in a format that Excel recognizes as such? e.g. 02-SEP/01:30Z
isn't a valid input. If you have true excel times, and you want to know if the time in B1 is
within 60 minutes of that in A1, the formula is =IF((B1-A1)<(1/24),"CONFLICT","")
 
-----Original Message-----
I am working in a sheet with a column of dates and times, for example
(02-SEP/01:30Z) . I need a macro or other function that can automattically
compare adjacent cells above and below and flag them in some way I.E> change
font color. This is a sheet to deconflict events that fall within an hour of
each other.

I'm not even sure which function to star up with.

Any Ideas out there.

Mike


.
Tried conditional formatting ?
Click to expand...
Menu 'Format', 'Conditional Fomatting' Select date
ranges, values as appropriate.
 
Back
Top