Yes, perhaps (for the benefit of those not familiar with this use of CF) I
should have made it clear that the font colour white advice was meant to go
with the CF ISNA() condition, and not to be applied as the basic format for
the cell. :-)
--
David Biddulph

"linda" wrote in message
...
and soon if the data is available,it cannot be seen;-)

"David Biddulph" wrote:

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Formula is: =ISNA(A1)

.... and at this point I should have added:
make the font colour white (or whatever your cell background is).

"Kirsty W" wrote in message
...
Thanks David and Jon,

I've now got it to work!
How should I use the conditional formatting to make the #N/A cells
look
empty?

"David Biddulph" wrote:

Whatever formula you're using to generate your cell contents, if it's
currently setting the result to "", get it to set to NA() instead.
[If
you
then also want to use conditional formatting to make the N/A# cells
look
empty, you can do so.]
...