Conditional Formatting
Thanks GS & Faraz, the issue is reolved now.
"Faraz A. Qureshi" wrote in
message ...
If using XL 2007:
=IFERROR(VLOOKUP(....),"")
Otherwise
=IF(ISNA(VLOOKUP(....)),"",VLOOKUP(....))
--
Thanx in advance,
Best Regards,
Faraz
"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?
|