Conditional formatting of font of fields

Applications Grid / Reports
#1

Hello Everyone,

I have a customer table with a field dob (date of birth). From it I calculate the Age of the person.

How do I make the Age value appear Red and Bold, based on condition (if Age < 18, then the font be Bold and Red)?

#2

If it’s on a grid you can apply conditional formatting in the onRecord event (add HTML formatting), e.g.

if ({Age} < 18) {
    {Age} = '<b><font color="red">' . {Age} . '</font></b>';
}