Hi All,

I have field "Type" which has values viz Process, Communication, Info, Total Errors, Total Successes.
I am trying to have different font color based on the value. The formula I use is:

if {command.type}="Process" then crnavy
else if {command.type}="Communication" then crnavy
else if {command.type} ="Info" then crnavy
else if {command.type}="Total Errors" then crteal
else if {command.type}="Total Successes" then crteal

It is just taking in the teal color for all. I do nitknow how should I go about it.

Thanks for your help,
Petronas

I agree with lockwelle's approach. A couple of things to try to tweak your formula if it is not working: