Conditional Highlighting

jurgster · January 2022

Hi,

Need some help with conditional highlighting.

IIF(FNEXTDATE<EncodeDate(Yearof(Date),Monthof(Date)+1,1),Fill=Red,Fill=None)

don't work just yet. I have missed something.....but what?

tony_c · January 2022

try

IIF(FNEXTDATE<EncodeDate(Yearof(Date),Monthof(Date)+1,1),Fill.backcolor=clRed,Fill.backcolor=clNone)

Regards

Tony

jurgster · January 2022

Thanks tony_c,

Unfortuneatly did not change background fill (highlighting).

tony_c · January 2022

I think the condition property has to evaluate to a boolean that toggles the fill.backcolor with the default color.

If you need more than a default and highlight color you might have to write some code in the beforeprint event of the memoview

gpi · February 2022

Try F_NEXTDATE < EncodeDate(Yearof(Date),Monthof(Date)+1,1) condition and set Color to clRed

Comments