public static void DrawConditions(Range pRange, Color color)
{
FormatConditions pConditions = pRange.FormatConditions;
Databar pCondition = pConditions.AddDatabar();
pCondition.MaxPoint.Modify(XlConditionValueTypes.xlConditionValueNumber, 0.5);
pCondition.MinPoint.Modify(XlConditionValueTypes.xlConditionValueNumber, 0);
pCondition.BarColor.Color = color;
pCondition.BarFillType = XlDataBarFillType.xlDataBarFillSolid;
}
