Hi Everyone, I need some help with changing the colour of some of my records if the "Target Date" field is less than today;s date. E.g. Highlight the record in "red" if the "Target Date" is less than today's date and highlight the record in "amber" if the "Target Date" is within the current month. What is the best way to do this, as part of the load script or as an expression in a a table box list. What will be the best functions to use. Thanks
There is no such option for Table Box Object, but you can do the same by using the Straight table, you can give back ground color by using the above solution, you can change the text color by using the "Text Color" expression, and you can give the text style by using "Text Format" expression like '<b>' for bold etc.