- if (makePeriod === "执行期" && (row === 3 || row === 4)) {
- const cfs = sheet.conditionalFormats
- let style = new spreadNS.Style()
- style.backColor = "#CCFFCC"
- style.foreColor = "#82bc00"
- cfs.addCellValueRule(spreadNS.ConditionalFormatting.ComparisonOperators.greaterThan, 8, 0, style, [new spreadNS.Range(row, 3, 1, 5)])
- }
复制代码
设置了数据验证,但是结果显示不对,公式要求是大于8的设置特殊样式,但是这里无论填什么值都设置了样式。
|
|