hi, thought that would work but maybe need way to separate each -general for
each level of conditional formatting? or for (same difference, using text)
good text output. anyways, that seems to (yellow) out all characters.
other problem is that it would yellow out all of my "good" yellow outputs,
where cond. formatting was skipped on those rows.

maybe example of what would need, if worked would be:
["xx"]"",general did not work either

variations tried
General;General;General;[Yellow]General
[Black]General;[Black]General;[Black]General;[Yellow]General
General[Black];General[Black];General[Black];General[yellow]

variations of output include: a0 br dd p0 p1 p2 p3 v1 v2
& xx / nothing ""


"T. Valko" wrote:

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