Hello,
I need to highlight rows on the condition they are 16 hours greater than the current date/time or less. I would like to use the conditional formatting in Excel but the formula seems to be my biggest trouble. Any help would be greatly appreciated.
SB
Try
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hi, Check out the attachment this is what you are looking for
This doesnt seem to be working. If the current date/time + 16 hours is less than the date/time in A and B, color the row. Is there a different formula that would work for this?
Last edited by smugglersblues; 08-16-2014 at 03:23 PM.
=AND(($A1+$B1)>=NOW()-0.6667,($A1+$B1)<=NOW()+0.6667) try this with conditional formatting
Sorry for the late reply. vogel this does exactly what I need. Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks