I'm trying to automatically highlight records that have been added or changed within a set time frame. I'd like to be able to set a certain time frame, either a specific date and time (ie, highlight everything changed after 08/30/18 10:20:30) or a time frame (highlight everything changed in the last 31 hours). I figured it will be a conditional formating thing, but I can't figure out the script for it.
You wouldn't need a script, you can set everything in the conditional formatting:
These will return a true value whenever your modified timestamp is greater than or equal to the timestamp you set, or the current timestamp minus 111,600 (the number of seconds in 31 hours) respectively.