FRangeConditionalFormattingMixin

addConditionalFormattingRule(rule: IConditionFormattingRule): FRange

clearConditionalFormatRules(): FRange

const fWorkbook = univerAPI.getActiveWorkbook()
const fWorksheet = fWorkbook.getActiveSheet()
const fRange = fWorksheet.getRange('A1:T100')

// Clear all conditional format rules for the range
fRange.clearConditionalFormatRules()
console.log(fRange.getConditionalFormattingRules()) // []

createConditionalFormattingRule(): FConditionalFormattingBuilder

const fWorkbook = univerAPI.getActiveWorkbook()
const fWorksheet = fWorkbook.getActiveSheet()

// Create a conditional formatting rule that sets the cell format to italic, red background, and green font color when the cell is not empty.
const fRange = fWorksheet.getRange('A1:T100')
const rule = fRange.createConditionalFormattingRule()
  .whenCellNotEmpty()
  .setItalic(true)
  .setBackground('red')
  .setFontColor('green')
  .build()
fWorksheet.addConditionalFormattingRule(rule)
console.log(fRange.getConditionalFormattingRules())

deleteConditionalFormattingRule(cfId: string): FRange

getConditionalFormattingRules(): IConditionFormattingRule[]

const fWorkbook = univerAPI.getActiveWorkbook()
const fWorksheet = fWorkbook.getActiveSheet()

// Create a conditional formatting rule that sets the cell format to italic, red background, and green font color when the cell is not empty.
const fRange = fWorksheet.getRange('A1:T100')
const rule = fWorksheet.newConditionalFormattingRule()
  .whenCellNotEmpty()
  .setRanges([fRange.getRange()])
  .setItalic(true)
  .setBackground('red')
  .setFontColor('green')
  .build()
fWorksheet.addConditionalFormattingRule(rule)

// Get all the conditional formatting rules for the range F6:H8.
const targetRange = fWorksheet.getRange('F6:H8')
const rules = targetRange.getConditionalFormattingRules()
console.log(rules)

moveConditionalFormattingRule(cfId: string, toCfId: string, type?: IAnchor['type'] = 'after'): FRange

setConditionalFormattingRule(cfId: string, rule: IConditionFormattingRule): FRange