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 colo...
Forum Discussion
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
------------------------------
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
------------------------------
