KatherineOakey
5 years agoQrew Member
Change color of field in report based on value
I have a Formula-Duration field that shows the number of days since the record was created.
roughly the formula is Today - ToDate([Date Created])
I would like to color code the value in the report so that 'old' durations are in, say Red, while middle age records are Yellow txt and new/current records (say < 30 days old) are either Green or Black.
I was also considering using the report color coding but Formula - Duration isn't an eligible field type.
------------------------------
Katherine Oakey
------------------------------
roughly the formula is Today - ToDate([Date Created])
I would like to color code the value in the report so that 'old' durations are in, say Red, while middle age records are Yellow txt and new/current records (say < 30 days old) are either Green or Black.
I was also considering using the report color coding but Formula - Duration isn't an eligible field type.
------------------------------
Katherine Oakey
------------------------------