1 of 1 people found this helpful
Use conditional formatting
What you're doing changes field data, e.g. the field will retain its colour even after the date has passed.
Why not use conditional formatting? Select a format and use
Self > Get ( CurrentDate) - 14 // and switch it off again? Add and Self <= Get ( CurrentDate )
to trigger it.
I of course looked at conditional, wondered how you would write it with 'value' between 1st date 2nd date etc but never even noticed the little drop down arrow to allow you to specify formula