Thread: How Can I use "#N/A" return from a vlookup to change row color?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
La La is offline
external usenet poster
  
Posts: 10
Default How Can I use "#N/A" return from a vlookup to change row color?
The row that returns "#N/A" from =VLOOKUP(H2,Compare!$A$2:$K$890,11,FALSE)
would help a lot by coloring the row green for non-#n/a and red for #n/a.
This way I know right away that the information exists in the other
speadsheet or not.
Reply With QuoteReply With Quote