Forum Discussion

AlanTibor's avatar
Qrew Member
2 years ago

Color code a record in a report

Hello QB SME's!!

I need help - I have a date field in a record that I need to color code based off of.
I need to color code records that are 45 days past the date in the record; AND I need to color code (in a different color) records when the date in that field is 30 days past TODAYS date!!

Please help!!

Alan Tibor

1 Reply

  • On a Table report you can use a row Colorization formula.

    Today() > [Date in the record] + Days(45), "Red",
    Today() > [Date in the record] + Days(30), "Yellow")

    There is a great choice of colors here, you can use the hex codes instead of the color names.

    Mark Shnier (Your Quickbase Coach)