Color code a record in a report

Question

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------------------------------

markshnier__you · Answer

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

IF(
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.

https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000000&dr=1

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Forum Discussion

Color code a record in a report