How to label the Expression in bold

[#1]

Please find the screen sheet

lots received and lar % and scar rate have the expressions .

I need the label in bold

[Nicole-Smith]

Right click on the label, then hit "Custom Format Cell".

[Nicole-Smith]

If "Custom Format Cell" is not available, make sure Styling Mode is set to Advanced in Document Properties:

[rustyfishbones]

Use Custom Format Cell and tick the bold tick box

[#5]

Hi Alan,

Thanks for the reply, if I have multiple tables, and I need to change(font, bold, color) all the fields.

Its taking a lot of time to change, by selecting each column. Is there any one time setting for this.

Eg:-

Setting -> User Preferences -> Font     "To choose the font for entire dashboard"

Thanks in Advance

Pavan Kumar.

[rustyfishbones]

Hi Pavan,

Yes, but you need to do this before you create and objects, charts, button etc....

But if you have created all of the objects already you probably need a macro to change previously created charts, objects, button fonts

There is a macro you can try to change all font to bold etc...

let me try find it

[rustyfishbones]

Hi Pavan,

Try this macro, it will change font, bold, italic and size but not color

SUB Font()

set sp = ActiveDocument.ActiveSheet.GetProperties

set sfont = sp.SheetFont

sfont.FontName = "Calibri"

sfont.Bold = True

sfont.Italic = false

sfont.Underline = false

sfont.PointSize1000 = 11000

ActiveDocument.ActiveSheet.SetFont sfont

END SUB

[rustyfishbones]

Pavan,

for the color, it's better to create variables for colors, so if you need to change the whole look of the application you could just change the variable once

I made a video on youtube about it

[#9]

thanks alan

[#10]

Amazing Alan, I'm a big fan of you.

Thank you very much.

Small request Alan, could you please share any link or documents to learn Macro's from the basics.

I'm very poor in Macro's.

Please help me out of this.

Thanks & Regards,

Pavan.