if exists ?

S

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
 
C

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
 
S

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
 
C

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Mismatched Data 5
MATCH OR VLOOKUP 3
Automatic Regressions based on Field Values 0
Vlookup or similar 7
VBA Macro to unfilter specific column 1
Lookup 14
Conditional Formatting 0
Help with Formula 2

Top