Color coding based on dates
Hi,
I'm trying to add color coding to my report for records that have a last revised date of on or before 2 years from the current day's date. Is there a formula for this? --------------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou can make a real colorization formula on the table report.
if(AdjustYear(Today(), -2) < [last revised date],"yellow")
You can use most of the color names or else select hex codes from here
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000010&dr=1
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------