Thread: Highlighting rows in a range where ID code does not exist in secondrange...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
travis[_3_] travis[_3_] is offline
external usenet poster
  
Posts: 58
Default Highlighting rows in a range where ID code does not exist in s
On Oct 1, 9:23*pm, Barb Reinhardt
wrote:
=ISNA(vlookup({the address of the cell containing ID105},S:S,1,false)).

Let's say you select all of the cells you want to check. *For this example,
I'm going to say it's C1:C1000 and you start on cell C1

In the conditional format, put this

=ISNA(vlookup($C1,S:S,1,false)).

Does that work?

Actually, yes, it did. Thanks.

Travis
Reply With QuoteReply With Quote