Color coding based on dates

Question

Hi,&nbsp;
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?------------------------------Amy Migliore------------------------------

markshnier__you · Answer

You can make a real colorization formula on the table report.&nbsp;&nbsp;

if(AdjustYear(Today(), -2) &lt; [last revised date],"yellow")

You can use most of the color names or else select hex codes from here&nbsp;
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&amp;qid=-1000010&amp;dr=1------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Color coding based on dates

1 Reply

Related Content

Color coding based on Next Due Date field

Google API QR Codes not working?

Color coding formula

Filter records based on table connection

Color coding formula based on another formula field

Recent Discussions

Convert Excel (once uploaded) to PDF inside QuickBase

Updating predecessors in a pipeline

Looking for State abbreviation to full spelling formula

Forced to use new dashboards?

Share your feedback on the new Qrew Discussions