Adding colour to formula

[sammybee77]

Hi All,

I'm sure this is possible but can't remember how. My formula reads

if isnull (field1) then 'STOP' else field1

I want the 'STOP' to appear in Red I though I could do this stating crred but I don't know where this goes. Please help.

Many thanks

Sam

 

[SmpTraining]

Insert the formula on the report then right click it and select format field. On the font tab, click the X+2 button alongside Color.

Enter the formula:

if {@formulaName} = "STOP" then crred Steve Phillips, Crystal Consultant