Conditional formatting?

[Titian]

I have a list of Post Code areas in column I followed by data in columns J&K.

I am selecting from that list of Post Code areas in column I e.g. CB5, to populate either column A or colum E then by use of a vlookup I am reading over the matching data from columns J&K.

What I would like to do is once a unique selection has been placed in either column A or E the matching entry in column I is formatted red if its in column A, yellow if its in column E - to show that the data in column I has been allocated.

Is this possible with CF or should I consider an alternative approach?

Thanks for your interest.

 

[wudhus_kid]

Use the formula part of conditional formatting & enter a logical argument for each case.

 

[Titian]

Thanks wudhus_kid your prompt was useful.

I am using "=NOT(ISNA(VLOOKUP(I5,$A$2:$A$298,1,0)))" to generate the "True/False" response required by CF.

 

[Peter_SSs]

Maybe also..
=ISNUMBER(MATCH(I5,$A$2:$A$298,0))

 

[Titian]

Yes Peter, works just as well

Thanks