Is there alternative way to highlight a cell like conditional formatting does

Jun 23, 2011 at 3:58 PM

Hi guys.

I'm generating Excel file using closedXML.

And I saw that Conditional formatting is in queue of items that is going to be supported soon.

I'm curious is there any other way i can use at this time to highlight a cell in two colors:

   red - where there is duplication in several cells

   green - where user fixed duplication error by editing cell content.


Thank You,

in advance for the answer.

Jun 23, 2011 at 4:04 PM

It may not be possible in your case but the only thing I can think of is creating a template with the conditional formatting and then open/fill/save it with ClosedXML.

Jun 24, 2011 at 1:37 PM

Thank You for the answer.

Can You guys tell me approximate date when You will release new version of ClosedXML with Conditional formatting support.

Jun 24, 2011 at 2:13 PM

Sorry, no ETAs. The best I can tell you is that I'll take a look at it after the next release (prolly in the next few days).

Jun 24, 2011 at 3:41 PM

Can You please write several words to this discussion page in case You will have any information regarding to Conditional formatting, or the time You will support it.

Thank You,

in advance for the answer.

Jun 24, 2011 at 4:15 PM