Description
When creating a conditional formatting rule where the condition is "cell value equals" a formula, the rule displays with a duplicate equal sign. The equal sign at the beginning of the formula input should be removed from the display to avoid the repetition with the "equals" operator.
Steps to Reproduce
- Create a new conditional formatting rule
- Set the condition type to "Cell value" and the operator to "equals"
- Enter a formula as the condition value (like
=SUM(1,1) or =1+9)
- Observe the rule display with a duplicate
= sign
Examples
IronCalc
Excel - conditional_formatting_issue_1166.xlsx

Description
When creating a conditional formatting rule where the condition is "cell value equals" a formula, the rule displays with a duplicate equal sign. The equal sign at the beginning of the formula input should be removed from the display to avoid the repetition with the "equals" operator.
Steps to Reproduce
=SUM(1,1)or=1+9)=signExamples
IronCalc
Excel - conditional_formatting_issue_1166.xlsx