当我设置"A>5andB=1背景为红"时,条件可生效 但是当我设置"(A>5orA<3)andB=1背景为红"时,相邻的单元格也会变红 怎么设置条件:不包括相邻单元格为空的 ds1: select * from input_pp_keyparameter t where substr(t.period,1,7) = '${date}' and t.factorycode='${factorycode}' order by t.period ds2: SELECT a.*,b.FACTORYCODE FROM BASE_PP_KEYPARAMETER a LEFT JOIN BASE_PP_FACTORYPARADIS b on a.id=b.id where ISUSE = 'T' and factorycode in ('${factorycode}') order by a.psort |