第二列填了实施日期后,第一列同行的单元格变绿色
=INDIRECT(ADDRESS(ROW(),COLUMN()+1,1))<>""
条件1、2、3分别为:
=AND(DATEDIF(A2,TODAY(),"D")<=30,DATEDIF(A2,TODAY(),"D")>15,B2="")
=AND(DATEDIF(A2,TODAY(),"D")<15,B2="")
=B2<>""