No it's not possible, the custom formats are only for
numbers


--


Regards,


Peo Sjoblom


"FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP
E-mail provider is) netzero.com wrote in message
...
Does an empty cell have a 'value'?

I want to CUSTOM FORMAT a range of cells such that:

IF the Cell is empty, display the word 'No'
-OR-
IF the cell contains a value other than 1, display the word 'No'.

[=1]"Yes"; [<1]"No";

Works great for 1's and 0's, but empty cells display no value at all and I
need them to display 'No'.

Thx! Doug
--
FirstVette52