if exists ?

[Steve]

Hi, I have two columns of data and wuld like to know if I can identify
if data in column A for example exists in column B.

For example

Column A Column B

Barrier Barrier
Strange Terrier
Colier Frontier
Terrier
Grange
Always
Frontal

Ideally what I would like to use the conditionally formatting facility
to format the data in Column C with a yellow background to highlight
the fact that the data exisits in both columns

Is this possible?

Thanks in advance

Steve

 

[Claus Busch]

Hi Steve,

Am Tue, 09 Oct 2012 09:16:53 +0100 schrieb Steve:

Column A Column B

Barrier Barrier
Strange Terrier
Colier Frontier
Terrier
Grange
Always
Frontal

Ideally what I would like to use the conditionally formatting facility
to format the data in Column C with a yellow background to highlight
the fact that the data exisits in both columns

select B1:Bn => CF => Formula =>
=COUNTIF(A:A,B1)>0


Regards
Claus Busch

 

[Steve]

Hi Claus and thanks for your quick reply.

I have clicked the conditional formatting icon in Excel 2007 and
chosen the option to 'Use a formula to determine which cells to
format'

I have then put in the following formula but although it accepts the
formula it does not highlight the cells with yellow background. I am
most definitely doing something wrong !!

="select HV152179:HVn => CF => Formula =>
=COUNTIF(Q152179:Q,HV152179)>0 "

The main data is in cells Q152179:Q152519 and column with the other
data in that I am trying to match starts at HV152179

Regards

Steve

 

[Claus Busch]

Hi Steve,

Am Tue, 09 Oct 2012 10:55:10 +0100 schrieb Steve:

="select HV152179:HVn => CF => Formula =>
=COUNTIF(Q152179:Q,HV152179)>0 "

The main data is in cells Q152179:Q152519 and column with the other
data in that I am trying to match starts at HV152179

the sentence with the arrows only tells the steps you have to go.
The formula is:
=COUNTIF(Q152179:Q152519,HV152179)>0


Regards
Claus Busch

 

[Steve]

Thanks Claus

Hi Steve,

Am Tue, 09 Oct 2012 10:55:10 +0100 schrieb Steve:


the sentence with the arrows only tells the steps you have to go.
The formula is:
=COUNTIF(Q152179:Q152519,HV152179)>0


Regards
Claus Busch