Different Colors for Different Fields 1

[codrutza]

Hello

I have in a report a group based on @Name: if {T.Name}='SUA' then 'A' else if {T.Name}='Europe' then 'B' else if {T.Name}=....

I have to put on A a color -crred, on B another color -crblue.... on 3 fields
- in Group Header on Group Name
- in Group Footer on the sum(sales)
- in Group Footer on the Group Name.

I tried in the formatting formulas for these 3 fields:
if 'A' then crred
else if 'B' then crblue....
but gives me an error.

Can you help me to figure out this?

 

[lbass]

If currentfieldvalue = 'A' then crred else
If currentfieldvalue = 'B' then ....etc.

-LB