How to specify "BOLD" font in a formula ? 1

I have looked & possibly missed it in help. but
how do I specify font formating in my formulas.?

if > //make bold then crRed //default font else crBlack

Is it possible to callout other formating of fonts in formulas ?? If so where do I find the white papers/articles ??

dtempleton

MIS

I haven't used it before, but you should be able to format it as HTML and then make all of the changes. Right-Click, Format Field, Paragraph Formatting, Text Interpretation, HTML Text.

boardburner

Technical User

Sorry. should have said I am in CR9
I think it might have an effect my answers.

boardburner

Technical User

Good idea but I am working with numbers. on option for paragraph.

dtempleton

MIS

if > then //make boldlable "" & totext( & "" //default font else "" & totext() & ""

lbass

Technical User

While highlighting the same field/formula and while you are in the font screen where you have formatted the color for the field/formula, go to style->x+2 and enter:

dtempleton

MIS

Then do the same thing for color->x+2 ?:

synapsevampire

Programmer

That's correct, conditionally set whatever attributes you want.

Or you can use HTML formatting if you're familiar with it, though this is usually done when you want to conditionally format part of a string, as it's more difficult to control and may cause alignment problems.

boardburner

Technical User

Thanks everyone for the info. I looked all thru help for the style types in formulas. came up empty.
Thanks again. all is good now.

boardburner

Technical User

This also bring up another question.
Is there a way to combine the syntax all into the same line in the formula. like

if > then crRed,crBold else crBlue,crRegular

I am not sure how to write this correctly.

lbass

Technical User

Then you would need to use dtempleton's solution, copied below and with a missing parenthesis restored. This assumes that the formula you want colored and bolded is the formula <@RawReqd>, so you will have to adapt this if this is not the field your want formatted. This converts the formula from a number to text. You then need to go to format field->paragraph->text interpretation->HTML text.