Conditional Number Formatting

[John]

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.

 

[Rick Rothstein]

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).