VSTO: ConditionalFormatting not working
Folks,
I'm trying to add a conditional format rule to a cell using Visual Studio
Tools for Office.
This code and others like it
((Excel.Range)rng.Cells[x,colnum]).FormatConditions.Add(
Excel.XlFormatConditionType.xlCellValue,
Excel.XlFormatConditionOperator.xlBetween, "=0.9999", "=100000");
cause a nasty exception that returns an error message featuring a
hexidecimal address where the error occurred.
Any clues?
--
Bob Sullentrup
|