Solved: Add Bold to Number Formating

[Djblois]

I am using a number formating to color anything negative red. I would also like to bold it. Is this possible in one line or do I have to bold it seperately?

.NumberFormat = "#,##0%;[Red]-#,##0%"

I know how to bold it seperately but I want to make my add-in smaller by doing it on one line.

[Bob Phillips]

Separately.

[Djblois]

I was wondering if it is possible to do a formula to put the min to max date in the right header from a column. I want it to look in my date column and then use the minimum date and maximum date to look like this (01\01\07-01\10\07). Is this possible?

[Bob Phillips]

See other thread.