Capture.PNG

Ok so here is the exact sheet I am working on. the task I need to do is if one day before the schedule date, N2, the serial field is blank, J2, then J2 should turn red. so for that first row, the schedule date is 2/8/2017, today being 2/7/2017 the cell should turn red since it has no serial number.