text formatting - colour and size

[Mikelevich]

Formatting text within a calc - no probs with colour OR size etc. But to format both the colour AND the size - I can't get the syntax right. I assume it's possible?

So as an example:

If ( Field1 = 1 ; TextSize ( Textfield ; 18 ) + TextColor ( Textfield ; RGB ( 0 ; 255 ; 0 ) ); "" )

 

So if Field1 =1 then I want the Textfield text to be size 18 and Green. What's the correct way of joining the two text formatting functions?

 

Hope someone can help.

[Mikelevich]

Dammit - just worked it out - in a moment of inspiration! The styles are nested - so my example should be:

If ( Field1 = 1 ; TextSize ( TextColor ( Textfield ; RGB ( 0 ; 255 ; 0 ) ); 18 ; "" )

 

Not sure what the hierachy is - I assume it's Style, Size, Colour - maybe it doesn't matter what order it's in - I'll have to experiment.

 

Thanks to anyone who's already responded.