ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Custom Number Formats (https://www.excelbanter.com/excel-programming/343892-excel-custom-number-formats.html)

Philip

Excel Custom Number Formats
 
Hi,

In the Custom Number format dialog, I can put a format like this:

#,##0_);[Red](#,##0);[Blue]"ZERO VALUE";[Green]"Text Value"

But how can I put Bold into that along with the colours? Is that possible in
Excel 2000, or XP ?

thanks

Philip

Niek Otten

Excel Custom Number Formats
 
Hi Philip,

Use Conditional Formatting instead.

--
Kind regards,

Niek Otten

"Philip" wrote in message
...
Hi,

In the Custom Number format dialog, I can put a format like this:

#,##0_);[Red](#,##0);[Blue]"ZERO VALUE";[Green]"Text Value"

But how can I put Bold into that along with the colours? Is that possible
in
Excel 2000, or XP ?

thanks

Philip




Zack Barresse[_3_]

Excel Custom Number Formats
 
Nope, not through Custom Formats, but it is through Format | Conditional
Formatting.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Philip" wrote in message
...
Hi,

In the Custom Number format dialog, I can put a format like this:

#,##0_);[Red](#,##0);[Blue]"ZERO VALUE";[Green]"Text Value"

But how can I put Bold into that along with the colours? Is that possible
in
Excel 2000, or XP ?

thanks

Philip





All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com