Datetime Highlight Cell

**Parth007** · 10-26-2015, 06:50 AM

I have a Column which contains datetime as below

2015/10/26 05:39:09 PM
2015/03/13 04:54:35 PM
2015/03/12 05:20:16 PM
.
.
.
.
.
.
And so on..

So the coumn cell value should be compared with System datetime.. & if their is differnece of more than one hour then the cell value should be highlighted..
Please assist any code

**igormigor** · 10-26-2015, 07:32 AM

=abs((now()-a1))>(0.0416666666666667)

**bsuperiorsystem** · 10-26-2015, 08:04 AM

Note:
you should use this formula in Conditional formatting (to be highlighted)

Please Login or Register  to view this content.

we use ABS to see the difference.
if you want the date that are later than NOW, you must remove ABS from code

**Parth007** · 10-26-2015, 09:40 AM

an we have a VBA code to do this, because the data in the sheet keeps on changing..

I mean the rows gets deleted and so the formatting also gets deleted..& then data gets populated again.. so if there is any code for this.. i would use it at the last of all.

I got below formula working

Please Login or Register  to view this content.

How would i use it as a VBA code for entire A column... please assist

Datetime Highlight Cell

LinkBack

Thread Tools

Rate This Thread

Display

Datetime Highlight Cell

Re: Datetime Highlight Cell

Re: Datetime Highlight Cell

Re: Datetime Highlight Cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] ISO datetime difference

[SOLVED] reference date time range, return the value into all cell that match datetime range

formatting datetime, US vs. UK

Based on a Column datetime value auto calculate and populate a datetime range

datetime question

[SOLVED] Highlight cells with ctrl-click but only un-highlight one cell

how do i perform a logical test on the time portion of a datetime formatted cell

Bookmarks

Bookmarks

Posting Permissions