View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Conditional Formatting

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:E1 0,2))

--
Gary''s Student - gsnu200909


"Panchi" wrote:

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?