ClosedXML / ClosedXML/ClosedXML.Report

How can I set conditional formatting properly?

Open
#178 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.