Conditional Number Formatting
 

I'd like to use a conditional custom number format where the font turns red
if the cell contains the text "Void". I tried something like:

0;(0);0;[Red][="Void"]

but it returns an error message. I know I can use conditional formatting but
I'd rather use the custom number formatting if possible.

Conditional Number Formatting
 

You can't "program" a cell format to look for a particular word, but if the
ONLY non-number that your cell can contain is the word Void, then you could
do use this Custom Format...

0;(0);0;[Red]"Void"

Note that no matter what NON-number is typed into the cell, it will display
as Void in red (so if you type, for example, BAD in the cell, the cell would
show Void in red).

--
Rick (MVP - Excel)


"John" wrote in message
...
I'd like to use a conditional custom number format where the font turns
red if the cell contains the text "Void". I tried something like:

0;(0);0;[Red][="Void"]

but it returns an error message. I know I can use conditional formatting
but I'd rather use the custom number formatting if possible.