GrapeCity Forums

this.fpSpread1.ActiveSheet.Cells[cc.rows, m + 5].Formula = "IF(OR(" + gs + (cc.rows - 1).ToString() + "=\"0\"," + gs + (cc.rows - 1).ToString() + "=\"\")," + gs + (cc.rows - 2).ToString() + "," + gs + (cc.rows - 1).ToString() + ")-" + gs + (cc.rows - 0).ToString() + "";

 If this cell value is less than zero, so I took him to change the background color.How do

 Hello,

I am not sure what formula you are using, however to change the background color of a cell for a given condition you may use SetConditionalFormat( ) method.Below is the code snippet that will change the back color of  the cell(1,1) if the value is less than zero,

Dim styleRed As New FarPoint.Win.Spread.NamedStyle()

FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleRed, FarPoint.Win.Spread.ComparisonOperator.LessThan, "0")

I hope it will help you.

Regards,