Hi,
Is it possible to add conditional formatting to a column which detects when a cell value is null (DBNull)? I want to highlight cells in my grid that are mandatory but haven't yet been populated. I have tried adding a ConditionalFormattingObject with ConditionTypes.Equal and tried "", null and DBNull.Value.ToString() but none triggered the formatting.
I have managed to get this working by using the CellFormatting event (thanks to help from this forum). Here I am able to check the cell value for DBNull and apply the following formatting;
e.CellElement.BackColor = Color.Red;
e.CellElement.DrawFill = true;
However this paints the cell backcolour red with a fade out - i.e. not blanket red which is what I want. Is this a setting somewhere, or part of the theme? If I use conditional formatting (tested with a non-null value) the cell is painted in plain red - i.e. no fading.
Therefore I would like to get the conditional formatting working with the null values - since this gives the formatting I require.
Thanks in advance,
Ben