I created a text calculated field, COMPARE, and I'd like to set each result as a separate color Worse (red), Better (green), No Change (black). Is this possible? Color option is not available if I check default properties on the field. Code is below. Would appreciate any assistance. Thanks.
<code>
IF ATTR([%0-6_CCT_ex-month]) > [%0-6_CCT_TOTAL] THEN "Worse" ELSEIF ATTR([%0-6_CCT_ex-month]) < [%0-6_CCT_TOTAL] THEN "Better" ELSEIF ATTR([%0-6_CCT_ex-month]) = [%0-6_CCT_TOTAL] THEN "No Change" ELSE " " END
</code>
Ah, I see what you're doing now. I don't think there's an easy way to do that in a single sheet like that. I'd be tempted to create another transparent floating sheet and colour the background behind the words - or you can colour the text instead.
