111035
想实现的效果(隐藏为空行的行高)大概每格单元格扩展的值如下:
C12={0,0,0,0,0}
E12={0,0,0,0,0}
G12={0,0,0,0,0}
C12={0,0,1,0,0}
K12={0,0,0,0,0}
M12={0,0,1,0,0}
O12={1,0,0,0,0}
下面是设过的条件(每个单元都设了相同的条件还是不奏效):
第一种:and(len(C12)=0,len(E12)=0,len(G12)=0,len(I12)=0,len(K12)=0,len(M12)=0,len(O12)=0)
第二种:C120,and G120,and K120,and O12<>0
第三种:len(C12)=0,and len(E12)=0,and len(G12)=0,and len(I12)=0,and len(K12)=0,and len(M12)=0,and len(O12)=0
第四种:ISNULL(C12),and ISNULL(E12),and ISNULL(G12),and ISNULL(I12),and ISNULL(K12),and ISNULL(M12),andISNULL(O12)
不知道是哪里出了问题,来请教大神们
编辑于 2018-7-25 11:50