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