Check Re: Howto color individual cells in a grid Message #992334

>
>i am generating a cursor dynamically whose column names vary depending on the choices made by the end-user of the software. the column names vary from PER01, PER02, PER03...upto PER12 and they all contain only NUMERIC data. The values contained in this cursor i am displaying in a grid.
>
>Depending on the columns chosen by the user, i store the column name in a form variable - ThisForm.cMonthPercent - along with the join condition - for example, "per01 < 50 Or per02 < 50 or per03 < 50" (the join condition will always contain only the < sign).
>
>i try to use this form variable in the following command -
>
>ThisForm.grdDetails.SetAll("DynamicForeColor","IIF(ThisForm.&cMonthPercent,RGB(255,0,0),RGB(0,0,0))","Column")
>
>but, i cannot get it to work.
>
>What i want to achieve is that if there are any values in the grid that are less than the number 50 (PER01 < 50 Or PER02 < 50 Or PER03 < 50), those numbers only should be highlighted in RED whereas the other numbers in the grid should be in BLACK.
>
>With reference to te above example, if any value in PER01 or PER02 Or PER03 is less than 50, it should be be in RED colour.
>
>Can someone help me achieve this result.
>
>With sincere thanks in advance.