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