Formula is: =ISNA(A1)
--
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.]
....