I have a running progress report to display request updates, but want to highlight the requests that have been updated in the last 7 days using color coding.
------------------------------
Ciara Harris
------------------------------
Question
Formula to highlight records on a report that have been modified/updated in the last 7 days
This topic has been closed for replies.
+24Hi Ciara, (just got off a call w/ Elise)
np
Use a formula like this to do row colourization on a table report.
IF(ToDate([Date Modified]) >= Today() - Days (7), "yellow")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
np
Use a formula like this to do row colourization on a table report.
IF(ToDate([Date Modified]) >= Today() - Days (7), "yellow")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.