I am trying to conditionally format a cell that is green for dates in the future (from today), red for dates in the past (before today) and black for two criteria, 1) date in the past and 2) when a cell has been marked as 'complete'. The first 2 work ok, but I can't get the black conditional...