I have 2 columns. I would like to highlight in red the first column IF it's blank AND the second column's date is 7 days or greater from the date in that cell. For example column 1, row 1 is blank and column 2, row 1 says 7/1/19. 7/1/19 is greater than 7 days old so I'd like the blank cell to become red, signaling that the blank needs to be addressed because the date is over 7 days old from when initiallentered.
