6 Replies Latest reply on Aug 2, 2012 10:36 AM by Modobird

    Conditional format of a certain field based on the modification date age

    Modobird

      Title

      Conditional format of a certain field based on the modification date age

      Post

      I have a "comments" field that I would like to have a red background for comments that are the most recent... say, not older than 10 days. I'm trying to use conditional formatting of the "comments" field, referencing the modification date. It's proving to be a lot harder for me than I thought.... can anyone tell me how to construct the formula? I am using Filemaker Pro 2011.