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

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

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