Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set text size in conditional formatting

In the properties of a chart, I have some expressions.

If I click on the plus sign of the expression I can set background color, text color, text format etc.

F.e. I have in text color the definition: If(1=1, Red() )

and in text format I have: If( 1=1, '<B><I>' ) making it bold italic.

Question: Which formula do I use to set the text size (making the font bigger)...

<H2> or something doesn't work. Or should I use a format expression around my value ? But how does that work...

9 Replies
Not applicable
Author

not sure there is a way with an html tag.  other posts suggest that <H1> - <H6> work but I tested on qv9 and qv10 and there was no change to the font.

Not applicable
Author

No that doesn't work, I tried it.

Or should I use a format expression around my value ? But how does that work...

Not applicable
Author

see if this works...

high light your control

click View menu

click Design Grid (box appears around control)

Ctrl + Shift + Right-Click on the cell you want to edit

click Custom Format Cell

in the Text settings box change the Text size

Apply Changes to "current expression"

Apply

Not applicable
Author

well, it works for ALL the lines, not just one...

Not applicable
Author

Hello,

Try to use single quates around the tag, ex. '<H5>'.

St0ny

Sokkorn
Master
Master

Hi,

Try to use this for text size (under Text Format): IF(1=1,'<H3>')

Regards,

Sokkorn

antonio_navas
Contributor II
Contributor II

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

antonio_navas
Contributor II
Contributor II

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

i try to learn better english

antonio_navas
Contributor II
Contributor II

Make as copys as you need of the calculate text, and make a conditional to view the result

(change the default colors as the result you want)

if(a>1)

i try to learn better english