In CF, choose "Formula Is" and use:

=ISNA(INDIRECT("rc",0))

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a worksheet with some cells that contain values
generated from a
VLOOKUP formula. Some of these cells contain a #N/A
error. (That's not the
problem.) I want to be able to use conditional
formatting to turn the cells
containing #N/A red, but for some reason I can't make it
work! Even on cells
that have values instead, a conditional format just
won't work.

Is this because I'm trying to do it on VLOOKUPs? Is
this an Excel glitch,
or is there something special I have to do?

Any help would be greatly appreciated!

Thanks,
JenniM
.