... MID(A1,5,1)=”-”,AND(VALUE(MID(A1,6,2))>=0, VALUE(MID(A1,6,2))<=99)) For a simpler approach, write. The following conditional formatting formula applies ...
確定! 回上一頁