comparing adjacent cells

[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

 

[Myrna Larson]

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","")

 

[steve]

-----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 ?

Menu 'Format', 'Conditional Fomatting' Select date
ranges, values as appropriate.