General information
Category:
Forms & Form designer
Not quite clear what do you mean, "aditionally", but try this:
ThisForm.libro1.Page1.Highlighted1.SetAll("DynamicForeColor","IIF(DVALE.Actividad == '900207' and DVALE.ValorT >= 0, RGB(0,183,0),IIF(DVALE.ValorT < 0, RGB(255,0,0),RGB(0,0,0))", "Column")
>Hi
>Still having problems with this setall instruction.
>I have A Grid With several columns one is DVALE.Actividad and other is DVALE.Valort. I need to turn green the lines when DVALE.Actividad ="900207" and aditionally I want to change that lines to red if DVALE.Valort < 0. Nick Neklioudov told me "You have to combine both conditions in one nested IIF and call .SetAll just once." and I tried this way but nothing; what am I doing wrong ?
>
>ThisForm.libro1.Page1.Highlighted1.SetAll("DynamicForeColor","IIF(DVALE.Actividad == '900207', RGB(0,183,0),(IIF(DVALE.ValorT < 0, RGB(255,0,0),RGB(0,0,0)))", "Column")
>
>Thanks
>
>Juan Uribe
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only