Hi,
I am using conditional formatting on an ultragrid that also supports manual formatting (like excel)
my problem is when i set the backColor of a cell then try to apply a conditional formatting, the cell's backcolor is overriding the conditional formatting applied.(same problem for the forecolor)
i had the same problem for the Bold, italic and underline... i solve it by replacing the False by Default when removing bold or italic or underline... but with the backcolor and forecolor is there a way to let the conditional formatting override the cell's appearance?
thx
Conditional Formatting is considered a column-level appearance in the resolution process, so anything set directly on the cell is going to override anything set on the column, by design. The appearances will be merged, but if you set a BackColor on the column and also on the cell, the cell's BackColor will show. The only way to let the conditional formatting show is to either not set the appearance on the cell, or use the InitializeRow event instead to set the appearances of cells based on a condition. If you take the latter approach, you could resolve the appearances yourself to determine which should take precedence.
-Matt
Is it possible to change the value of a cell on the basis of some condition as we change the color of cell.
Actually my requirement is like I need to display blank if teh cell value is 0, for this I am using conditional formatting and on the basis of condition i want to set the value for a particular cell. I tried e.Cell.Content = ""; but it doesn't work.
Can you please let me know how i could achieve this?