Hey guys,

I have a situation I've never encountered before and am having some trouble with it.

I have a column with vlookups in each cell that return a specific date and time from data that I dump into this file each day. I'm trying to set up conditional formatting to highlight the cell and text in red IF the value in the cell, returned by the vlookup, falls before the current day at 9:00:00 am. For example, if the value returned in the cell says Wednesday, April 1, 2015 1:00 PM, I want it to highlight in red. Even if it shows today's date but 8:59 AM or before, I also want it to highlight the same way.

Everything I've been able to come up with so far hasn't done the trick.

Thank you. If you need further clarification, let me know.