Now why didn't I think of it like that? I will the next time. The pupil
learns!

Question - without testing: if they had
=IF(ISNA(formula),"",formula)
in the cell, then =ISNA(D3) wouldn't work would it? Darn, now I've got to
go check.

"Jon Peltier" wrote:

Or just ISNA with the cell that contains #N/A (less calculation required):

=ISNA(D3)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Yes,
In the conditional format setup, choose Formula Is rather than value is
and
enter the condition that would result in a #N/A error.
Lets say that your cell's actual formula is
=VLOOKUP(A1,B1:C10,2,0)
and it results in an #N/A when there's nothing in A1 (or no match in the
B1:C10 table).
in the conditional format setup, after choosing Formula Is then enter
this:
=ISNA(VLOOKUP(A1,B1:C10,2,0))
and set your format conditions accordingly.

"Ken" wrote:

Hi!

Is there any way to use conditional format to make the cell black, when
the
formula results of cells are #N/A.

Thank you very much!

Ken