Maybe this:

General;General;General;[White]General

*ALL TEXT* entries will appear in a white font. Change White to be the same
as the fill color. However, conditional formatting will take precedence.

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
hi, that would otherwise work, but am using all 3 cond. formats
really just need to hide a double x: xx
use not so important, but have lines that are below value, they are
formula'ed to turn off in such a case, e.g.: if levels less than 50,
display
nothing:
=IF(quantity<50,"",else true sorts unwanted records to top, need them
to
bottom, replace "" with: "xx"; do not want to see the "xx".

"T. Valko" wrote:

have a column want to sort "off-lines" to end, instead of NOT situation
="",
have to use characters..

Sorry, I have no idea what that means.

How about using conditional formatting to set the font color to be the
same
as the fill color?

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
yes, for text, e.g.: xx
have a column want to sort "off-lines" to end, instead of NOT situation
="",
have to use characters.. (do not see a ready made custom format for
text).

"T. Valko" wrote:

To "hide" 0s:

0;-0;;@

But I'm guessing you want to do it for some other value!

--
Biff
Microsoft Excel MVP


"Nastech" wrote in message
...
hi, is there a way to make a specific text, in a column to "not"
appear?
have tried variations on use of 0 example:

[=0]"";0 can not get to work for text, thanks