Conditional Formatting

[Panchi]

I have a sheet that already has conditonal format where every 3rd row is
highlighted green (the cond. format formula is =MOD(ROW(),3)=1 ).

Now I want to add another condition where the #N/A is not visible. Its OK
for all the rows that are not highlighted but it still shows the error in the
rows still highlighted. how can i work around this?

 

[Gary''s Student]

You can avoid the problem with =ISNA(). for example, rather than:
=VLOOKUP(A1,D1:E10,2)
use:
=IF(ISNA(VLOOKUP(A1,D1:E10,2)),"",VLOOKUP(A1,D1:E10,2))

 

[Faraz A. Qureshi]

If using XL 2007:
=IFERROR(VLOOKUP(....),"")
Otherwise
=IF(ISNA(VLOOKUP(....)),"",VLOOKUP(....))

 

[Panchi]

Thanks GS & Faraz, the issue is reolved now.

If using XL 2007:
=IFERROR(VLOOKUP(....),"")
Otherwise
=IF(ISNA(VLOOKUP(....)),"",VLOOKUP(....))

--
Thanx in advance,
Best Regards,

Faraz