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?