用条件格式比较容易达到效果,选中想变色的区域,条件格式,
公式为:=OR(AND($A1>=60,$A1<=75,B1<7000),AND($A1>=76,$A1<=80,B1<1500000))
OR(AND(A3>=60,A3<=75,C3<70000),AND(A3>=76,A3<=80,C3<1500000))