excel函数公式求助

仅供参考 Sub 双条件合并值及判断颜色() Dim arr, i, stra, stracol, strb, strbcol, coll arr = ActiveSheet.Range("a1").CurrentRegion For i = 1 To UBound(arr) If arr(i, 6) > 3 Then If arr(i, 11) = "否" And a