"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).

--
David Biddulph

"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.]
...