Example:
Assuming the VLOOKUPs are say, in A1:A10
To mask the possible returns of #N/As
within the VLOOKUP range with conditional formatting ..
Select A1:A10
(ensure A1 is the active cell)
Click Format Cond Formatting
Formula is: =ISNA(A1)
Click Format button Font tab Font color white*? OK
Click OK at the main dialog
*choose a font color which matches the cell's fill color
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---