Conditional Formating in CE9 1

[YANKRAY]

Using CE9, I know how to conditionally set the font color.

Is there a way to conditionally set an Underline or Bold?

Some of the users do not have color printers, so I thought using Underline or Bold would be a better approach.

 

[kskid]

I've done it with the format editor in 8.5 but not sure about 9.0

 

[YANKRAY]

Yes, I know where to do it, I do not know the codes for underline or bold.

 

[lbass]

For a conditional underline, go to the x+2 formula area for underline (format->field->font->underline) and enter:

if {table.amt} > 500 then true //substitute your condition

For bold, on the same screen go to style->x+2 and enter:

if {table.amt} > 500 then crBold else crRegular

-LB

 

[Madawc]

In 8.5, the codes for style are to be found as the second item on Functions when you're in the Formula Field editor. Llikewise for colour, font, though for Font Size you have to enter a number like 8, 11 or whatever you seek.

Madawc Williams (East Anglia, UK)