Does anyone know of a way to programatically get the Conditional Formatting color of a cell, specifically from Color Scales?
Using IRange.CellStyle.Color I can get the fill color of a cell. However if the user has created a Conditional Formatting Color Scales I haven't been able to figure out how to get the cell color.
I've figured out that IRange.ConditionalFormats gives me access to the information about the conditional formats and I can interrogate each individually. I can also use the IConditionalFormat.FormatType to determine if it is a ColorScale. I was hoping that there was a property that would just provide me color, but since I don't see that I tried to go the route of calculating it.
I've attached a really simple example excel workbook that has 6 formatted cells. Using IConditionalFormat.ColorScale.Criteria I believed that I could try to compare the cell text to the Criteria's Value using the Operator and then know which color. However, even though I have 6 unique colors I'm only getting 3 criteria.
tl;dr: Is there property that provides the cell color being set by Conditional Formatting, if not is there a way to figure it out and specifically for ColorScale Conditional Formatting?
Thanks,
Travis
Attachment:
Book1_87b56ac9.zip
