Good day,

I am attempting to underline the row (A:D) that contains the last occurrence of a date/time in range of numerous chronologic dates/times. Essentially I just need to add visual aid to the spreadsheet to make the transition from one day to the next more clear. I have been able to do this (in the past) with only dates. But adding the time element has pushed me into deeper "excel" waters. For further detail, the range that I am working with is not raw data, rather it is populated via index-match array fx from a separate data entry sheet. See screenshot.

SOF.jpg