I am trying to highlite W3 when W3= (the letter H) and AA3 is blank. AA3 has the following formula: 
=IFERROR(HYPERLINK("#"&ADDRESS(MATCH(IFERROR(MATCH(V816,H:H,0)," "),$A$3:$A$6065,0),1,4,1,"COMPARISON VIEW"),VLOOKUP(IFERROR(MATCH(V816,H:H,0)," "),$A$3:$A$6065,1,0)),"")