Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression to control the colour of a text field
=if ([# Late Quantity] > 0, RGB(255,0,0),RGB(0,0,0))
How can I make it bold as well.
Thanks
Andy
Hi,
DO you want to make it bold conditionally ?
HI
In Format text within the expression use ='<B>' or add it to an if statement.
Mark
Under Expression, You need to put the text format like --- '<b>'
If you have this requirement for Text box then no way you have to use two text boxes one with bold in font tab, otherwise if it is in straight table or pivot or any chart as others said you need to go to
chart properties -> Expressions tab -> click the '+' symbol and go to text format and in the window type ='<B>'
You may use macros to change bold in text box, like this:
sub ChangeBold
set mybox = ActiveDocument.GetSheetObject("TX22")
mbp = mybox.GetProperties
mbp.Layout.Frame.Font.Bold = true 'or false, if you need no bold text.
mybox.SetProperties mbp
end sub
Hi Andy,
easy peasy:
HTH
Andy
Thank you to everyone for your quick replies.
Andy