Formatting Group Summary Fields

[Rob2k2]

I have got a report where the data is summarised and grouped by lender, i.e. green, red, etc. Is there a way to change the font colour to relate to the lender, i.e. have the text in green if the lender is green?

 

[skuhlman]

select the field and press "FORMAT... FONT..."

to the right of the COLOR selection is a button with "X-2" on it. Press that button.

Enter a formula there to select the color... something like

if lender='green' then GREEN else
(if lender='red' then RED else
(if lender='yellow' then YELLOW else
BLACK))
[b/]

 

[Rob2k2]

Thanks a lot, that was easier than expected