is there any way to find out which conditional formatting is currently active in a cell? When I look at the ConditionalFormats property, it only lists the formattings that could apply (is there possibly an IsActive property somewhere?).
Using the Excel Interop interface, I have been able to check this via Range.Cells[x, y].DisplayFormat.
I couldn't find anything in the documentation, did I miss something?