5 Replies Latest reply: May 20, 2015 9:27 AM by Peter Hargreaves RSS

    Conditional Formatting

      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