ClosedXML / ClosedXML/ClosedXML.Report
How can I set conditional formatting properly?
- Dominant language
- C#
- Stars
- 647
- Forks
- 122
- PR merge metrics
- No merged PRs in 30d
Description
When the value in cell C2 is {{item.numericvalue}}, I have tried using conditional formatting to make the background color different depending on the interval of the value.
like this
100 <= x < 150 red
151 <= y < 160 blue
So I added the following two conditional formatting to cell C2.
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue
And in the output after binding the list, there were 2 additional conditional messages attached to cell C2, resulting in a total of 4 formats.
like this
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue
=AND(100<=C2,C2<150) ===> red
=AND(151<=C2,C2<160) ===> blue
Whenever I add conditional formatting, it seems to overlap and it takes longer to save. Is there any solution??
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.