Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
whole number conditional formatting | Excel Worksheet Functions | |||
Conditional Number Formatting | Excel Worksheet Functions | |||
Whole Number Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Number formatting? | Excel Discussion (Misc queries) | |||
odd and even number conditional formatting | Excel Discussion (Misc queries) |