"Ron Rosenfeld" wrote:
On Sat, 8 Oct 2011 10:03:54 -0700, "joeu2004" wrote:
Even if "this" had referred to CF in general, I simply overlooked an
arguably clever use of it.
[....]
The reason I raised the question about using CF was
because an hour earlier, someone had posted using the
change of the font color to make the cell appear blank in CF
[....]
It never occurred to me that you were unaware of that technique.

I am not "unaware" of it. I said I [might have] simply "overlooked" it
(i.e. forgot about it).

But actually, looking back at the discussion to refresh my memory, I see
that:

1. Claus wrote: ``For text "null" use the conditional format: if cell value
is text "null" then font color is white``.

2. And Cortez responded: "That's virtually the same as what I have atm, but
was looking for
something more eloquent. I was hoping that there was a similar conditional
operater function for the text section as there is for the numeric sections
where [100] dictates when to apply the format".

So why would I reiterate a method that Cortez already rejected?
(Rhetorical.) If I had, I'm sure you would have bleated, "Why are you
repeating a suggestion that Cortez already rejected?".

Instead, I addressed my comments to his original request for a "custom
[number] format" per se. I wanted to make the point that such features
might be version-specific, and if Cortez uses XL2007 and later, he/she
should look at CF for some format enhancements as there are for numeric CFs
(IIRC). But I also set expectations that I did not expect any for text
formats per se.

I posted my comments 3 hours before you offered essentially the same answer
in fewer words.

That's about all I will say on this matter. It is a distraction. I try to
focus my attention and comments on issues that I think will benefit the OP,
occassionally nitpicking others' comments again only when I think it will
benefit the OP.