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