I have a property which is a radio button (Yes/Maybe/No). I would like to be able to set this as a conditional coloring in a report so in the table of data, the Yes is green, the Maybe is yellow and the No is red. Currently you can only do conditional formatting on number fields. And you cannot make radio buttons numeric. The only solution I found, which is far from optimal, is to make another property, of number type, with a formula based on the value in the first property so that I can use the conditional number formatting for max/min. The problem, and why not optimal, is that I actually have 15 of these fields, so that means I had to make 15 calculated formula fields to do what I want. And also, in the table view, they display as 2/1/0 instead of Yes/Maybe/No to get the coloring.
...read more