Is there anyway to use the red, yellow, green icons that come with conditional formatting for an iconset on fixed numbers within a cell. Basically, we want to say:
If number < -0.5 show RED
If number between -0.5 and 0.5 show YELLOW
If number > 0.5 show GREEN
It appears that this is percentage based.
If there is another route we can try, that would be OK too. Based on the documentation, this seemed like the most logical path.
Thanks
Hi,
I am afraid, Aspose.Cells for .NET does not support IconSet and partially support conditional formatting.
Please refer to this document: Conditional Formatting
Hi,
Correction: Conditional Formatting is supported, you should check the document given by me before.
Please check doc about Conditional Formatting in Microsoft Excel 2007 on
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/conditional-formatting.html