第一种方式 用添加GridFormatRule 规则
GridColumn colRate = gridView1.Columns["Rate"];
colRate.DisplayFormat.FormatType = FormatType.Numeric;
colRate.DisplayFormat.FormatString = "0.00%";
GridFormatRule gridFormatRule1 = new GridFormatRule();
gridFormatRule1.Name = "Format0";
FormatConditionRuleValue ormatConditionRuleValue1 = new
FormatConditionRuleValue();
ormatConditionRuleValue1.Value1 = 0.98;
ormatConditionRuleValue1.Condition = FormatCondition.Less;
ormatConditionRuleValue1.Appearance.BackColor = Color.Red;
ormatConditionRuleValue1.Appearance.BackColor2 = Color.Red;
ormatConditionRuleValue1.Appearance.Options.UseBackColor = true;
gridFormatRule1.Rule = ormatConditionRuleValue1;
gridFormatRule1.Column = colRate; //应用于该列
this.gridView1.FormatRules.Add(gridFormatRule1);
第二种方式 用RowCellStyle方法手动判断(行和单元格标红都可以)
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
string val = gridView1.GetRowCellValue(e.RowHandle, "strRate") != null ? gridView1.GetRowCellValue(e.RowHandle, "strRate").ToString() : "0";
if (val != null && val.Contains("%"))
{
val = val.Replace("%", "");
}
double value;
if (double.TryParse(val, out value) && value < 98)
{
e.Appearance.BackColor = Color.Red; //良率小于98%标红
//e.Appearance.BackColor2 = Color.Red; //良率小于98%标红
}
}