>>How do I change the color of cells in a column depending on criteria in a table?
>>
>>i.e. If a part has been ordered I want the cell in only the first column to be blue. If it has been received I want it to be green. If it is on back order then red, etc.
>
>Instead of SetAll, just use:
>
>THISFORM.Grid1.Column1.DynamicBackColor = "IIF(MyCondition,255,0)"
>
>to set a single column.
Eric,
I changed "IIF(MyCondition,255,0)" to "myfunction()" and it works wonderfully. I know it had to be that simple but I just could not find the right answer.
Thanks a million.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn