Hi All,
On desktop list, I would like to change the background color of the cell is the value is below margin. When I export to excel, I need to cells to be red as well.
I see that the "this.list" control is available but the color did not change at all.
foreach(Sage.Common.Controls.ListItem r in this.list.Items)
{
if ((decimal)r.SubItems[7].Value <= 10)
{
r.SubItems[7].BackColor = System.Drawing.Color.Red;
}
}
I try adding the snippet on GetColumnsProtected(), on ItemRefresh event, ItemAdd event and many more. But seems like it did not change anything. Even my MessageBox.Show("testing"); is not triggered.
Is there any way to achieve this? Thank you.