Conditional format of a certain field based on the modification date age
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.