so all I want to do is have J2 turn red if it is blank one day before the schedule date. so the schedule date is 2/8/2017 and today is 2/7/2017, since there is not serial number in j2 it should turn red.