IXlsConditionalFormatting

COM interface ( getting help with interfaces )

interface IXlsConditionalFormatting : IDispatch
{
  [id(1),propget] HRESULT CellCondition([out, retval]IXlsCellCondition** cc);
  [id(2),propget] HRESULT FormulaCondition([out, retval]IXlsFormulaCondition** fc);
  [id(3),propput] HRESULT Style([in]IXlsStyle* style);
  [id(4)        ] HRESULT AdditionalCondition([out, retval]IXlsConditionalFormatting** ac);
  [id(5)        ] HRESULT Delete();
  [id(6)        ] HRESULT DeleteAll();
  [id(7),propget] HRESULT Areas([out,retval]BSTR* cellrange);
  [id(7),propput] HRESULT Areas([in]BSTR cellrange);
  [id(8),propget] HRESULT PredefinedCondition([out, retval]IXlsPredefinedCondition** pc);

}

HRESULT CellCondition([out, retval]IXlsCellCondition** cc);
creates a cell-based condition.

HRESULT FormulaCondition([out, retval]IXlsFormulaCondition** fc);
creates a formula-based condition.

HRESULT Style([in]IXlsStyle* style);
sets the formatting changes when the condition is valid.

HRESULT AdditionalCondition([out, retval]IXlsConditionalFormatting** ac);
adds another condition. Conditions are logically linked with an OR operator.

HRESULT Delete();
deletes the condition.

HRESULT DeleteAll();
deletes all the conditions.

HRESULT Areas([out,retval]BSTR* cellrange);
returns the areas where the conditional formattings apply. The returned range is semi-colon separated, of the form RxCxx:RyCyy.

HRESULT Areas([in]BSTR cellrange);
sets the areas where the conditional formattings apply. The returned range is semi-colon separated, of the form RxCxx:RyCyy.

HRESULT PredefinedCondition([out, retval]IXlsPredefinedCondition** pc);
picks a predefined conditional formatting.