You'll need to make sure your report name is formula rich-text, and then something like this will work:
var bool overdue = (Today() - [Last Opened Date]) > Days(120);
var text name = [Field that actually has the report name]; //This is the text that will show in your element
"<p style='text-align:center; width: 100px; " & if( $overdue, "background: red; color:white;"'>" & $name & "</p>"
The <p> tag just make it a block element so you can set a standard width to make the column look the same width up and down, adjust as needed. In the above I just have it setting the background to red and font-color to white, you can plug in your own hex color or alternate color though as needed.
Chayce,
I'm trying to do something similar but your last line above is missing a closing parentheses or something. I'm getting an error "expecting )," but i can't seem to figure out how to solve it. I've added the ), but the error just moves down to the </P> box with "expecting text." I've copied your formula and input my own fields, etc, otherwise I've made no changes. Any ideas?
Qrew LegendChris,
It's hard for us to help you without seeing your formula. Please copy and paste the code as an update to this thread. ie not a screen shot but a copy paste of the code.
