不能录制的原因是公式太长了,你把公式简化一下就能录制了.---------将公式变为VBA语言,如:if cells(1,"B")>0 and cells(1,"B")<130 and cells(1,"E")>5 and cells(1,"A")="IMAGE" then......等等,这种格式