I am using Crystal Reports 2011.
I have a formula, @Classification, that has four possible results:
First
Expanded
Reserve
Quarantine
I want the font color to change based on the result of that formula. Since orange is not available as a conditional formatting color, I have set the font color of the field to orange and then applied conditional formatting.
If {@Classification} = 'First'
then crGreen
else
if {@Classification} = 'Expanded'
then crBlue
else
if {@Classification} = 'Reserve'
then crBlack
The problem I am encountering is that once I apply the conditional formatting, 'Quarantine' is no longer orange. It changes back to black. But the colors of the other classifications are correct.
How can I resolve this?