Bordereaux").Range("T14").Formula = "=IF(AND(J14="",E14=""),SUM(F14*F14*H14)/1000,IF(O14="",SUM((H14*F14*G14)+(M14*K14*L14))/1000,SUM((H14*F14*G14)+(M14*K14*L14)+(R14*P14*Q14))/1000))"
Next ipaste
例如:如果值大于"G14“+”E14“,我想突出显示”D14“红色。负号反之亦然。如果"E14“的值为空,它仍然会使其变为红色,因为它的行为就好像它是零一样。Dim cond1 As FormatCondition, cond2 As FormatCondition, cond3 As FormatCondition
'clear any existing conditio