dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid 1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks

Gerald
You must understand that no one who is reading what you wrote has any
idea about what you mean by the terms you use. Please post back and explain
what you have, what you want to have, and how you want to get from one to
the other, and do it all in plain common words. For instance, explain:
"empit 1"
"displayed as addition"
"displayed as deletion"
HTH Otto
"Gerald" wrote in message
...
dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will
be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid
1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks

How did things get to be red, yellow or green in the first place? And by
"highlighted" do you mean the font/text is colored or the cell background is
colored?

Keep in mind that formulas in cells can't determine the color of a cell's
font (text) or background. A solution using colors is going to take VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid 1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks

apologies for not been clear, allow me to explain again with below e.g.

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not have
00010, it should display in column 3 as addition

hope I was clear now

Thanks for looking into my query


"Otto Moehrbach" wrote:

Gerald
You must understand that no one who is reading what you wrote has any
idea about what you mean by the terms you use. Please post back and explain
what you have, what you want to have, and how you want to get from one to
the other, and do it all in plain common words. For instance, explain:
"empit 1"
"displayed as addition"
"displayed as deletion"
HTH Otto
"Gerald" wrote in message
...
dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will
be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid
1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks

Gerald
What does "it should display in column 3 as addition" mean? Exactly
what do you want to see in column 3? And what is the rational that would
drive column 3 to "display as addition"? HTH Otto
"Gerald" wrote in message
...
apologies for not been clear, allow me to explain again with below e.g.

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not
have
00010, it should display in column 3 as addition

hope I was clear now

Thanks for looking into my query


"Otto Moehrbach" wrote:

Gerald
You must understand that no one who is reading what you wrote has any
idea about what you mean by the terms you use. Please post back and
explain
what you have, what you want to have, and how you want to get from one to
the other, and do it all in plain common words. For instance, explain:
"empit 1"
"displayed as addition"
"displayed as deletion"
HTH Otto
"Gerald" wrote in message
...
dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1
will
be
present though one hightligted in yellow and another highlighted in
green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen
and
if no corresponding yellow then it has be displayed as additon or if
empid
1
(yellow) is seen and if no corresponding red then it has be displayed
as
deletion

would really appreciate any help on this

thanks

below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place? And by
"highlighted" do you mean the font/text is colored or the cell background is
colored?

Keep in mind that formulas in cells can't determine the color of a cell's
font (text) or background. A solution using colors is going to take VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid 1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks

Gerald
We are not connecting. To "display as addition" means nothing to me.
Don't say that column 3 "should display as addition". Tell me exactly what
you want to see in column 3 and also tell me why column 3 should show that.
In other words, what is the logic behind what you want to see in column 3?
HTH Otto
"Gerald" wrote in message
...
below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not
have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place? And by
"highlighted" do you mean the font/text is colored or the cell background
is
colored?

Keep in mind that formulas in cells can't determine the color of a cell's
font (text) or background. A solution using colors is going to take VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1
will be
present though one hightligted in yellow and another highlighted in
green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen
and
if no corresponding yellow then it has be displayed as additon or if
empid 1
(yellow) is seen and if no corresponding red then it has be displayed
as
deletion

would really appreciate any help on this

thanks

I'm pretty sure no-one here has a clue what you are trying to achieve,
so try this in cell C1

=IF(A1:A3<00010,"as addition","")


George Gee



"Gerald" wrote in message
...
below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not
have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place? And by
"highlighted" do you mean the font/text is colored or the cell background
is
colored?

Keep in mind that formulas in cells can't determine the color of a cell's
font (text) or background. A solution using colors is going to take VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1
will be
present though one hightligted in yellow and another highlighted in
green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen
and
if no corresponding yellow then it has be displayed as additon or if
empid 1
(yellow) is seen and if no corresponding red then it has be displayed
as
deletion

would really appreciate any help on this

thanks

Hi George

Not sure I am going to fair any better than you at interpreting Gerald's
requirement, but here goes

Does List1, List 2 List 3 refer to named ranges?
If so, then maybe in C1
=IF(COUNTIF(INDIRECT(A1),B1),"","as addition")

--
Regards

Roger Govier


"George Gee" wrote in message
...
I'm pretty sure no-one here has a clue what you are trying to achieve,
so try this in cell C1

=IF(A1:A3<00010,"as addition","")


George Gee



"Gerald" wrote in message
...
below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does
not have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place?
And by
"highlighted" do you mean the font/text is colored or the cell
background is
colored?

Keep in mind that formulas in cells can't determine the color of a
cell's
font (text) or background. A solution using colors is going to take
VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1
will be
present though one hightligted in yellow and another highlighted
in green

I am doing a comparision on column empid i.e. if empid 1 (red) is
seen and
if no corresponding yellow then it has be displayed as additon or
if empid 1
(yellow) is seen and if no corresponding red then it has be
displayed as
deletion

would really appreciate any help on this

thanks

Hi Roger

Maybe one of us is on the right lines, not sure,
but I think we're only scratching the surface here.
We've not yet addressed the colour comparisons
in the original post!

Also I would dearly like to know what "empid" means,
sounds fascinating.

George Gee


"Roger Govier" wrote in message
...
Hi George

Not sure I am going to fair any better than you at interpreting Gerald's
requirement, but here goes

Does List1, List 2 List 3 refer to named ranges?
If so, then maybe in C1
=IF(COUNTIF(INDIRECT(A1),B1),"","as addition")

--
Regards

Roger Govier


"George Gee" wrote in message
...
I'm pretty sure no-one here has a clue what you are trying to achieve,
so try this in cell C1

=IF(A1:A3<00010,"as addition","")


George Gee



"Gerald" wrote in message
...
below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not
have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place? And
by
"highlighted" do you mean the font/text is colored or the cell
background is
colored?

Keep in mind that formulas in cells can't determine the color of a
cell's
font (text) or background. A solution using colors is going to take
VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1
will be
present though one hightligted in yellow and another highlighted in
green

I am doing a comparision on column empid i.e. if empid 1 (red) is
seen and
if no corresponding yellow then it has be displayed as additon or if
empid 1
(yellow) is seen and if no corresponding red then it has be displayed
as
deletion

would really appreciate any help on this

thanks

Hi George
Also I would dearly like to know what "empid" means,

My guess is Employee ID?


--
Regards

Roger Govier


"George Gee" wrote in message
...
Hi Roger

Maybe one of us is on the right lines, not sure,
but I think we're only scratching the surface here.
We've not yet addressed the colour comparisons
in the original post!

Also I would dearly like to know what "empid" means,
sounds fascinating.

George Gee


"Roger Govier" wrote in message
...
Hi George

Not sure I am going to fair any better than you at interpreting
Gerald's requirement, but here goes

Does List1, List 2 List 3 refer to named ranges?
If so, then maybe in C1
=IF(COUNTIF(INDIRECT(A1),B1),"","as addition")

--
Regards

Roger Govier


"George Gee" wrote in message
...
I'm pretty sure no-one here has a clue what you are trying to
achieve,
so try this in cell C1

=IF(A1:A3<00010,"as addition","")


George Gee



"Gerald" wrote in message
...
below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does
not have
00010, it should display in column 3 as addition



"JLatham" wrote:

How did things get to be red, yellow or green in the first place?
And by
"highlighted" do you mean the font/text is colored or the cell
background is
colored?

Keep in mind that formulas in cells can't determine the color of a
cell's
font (text) or background. A solution using colors is going to
take VBA
coding.

"Gerald" wrote:

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid
1 will be
present though one hightligted in yellow and another highlighted
in green

I am doing a comparision on column empid i.e. if empid 1 (red)
is seen and
if no corresponding yellow then it has be displayed as additon
or if empid 1
(yellow) is seen and if no corresponding red then it has be
displayed as
deletion

would really appreciate any help on this

thanks

Hi Roger

Ah, not very exciting after all......!

George Gee


"Roger Govier" wrote in message
...
Hi George
Also I would dearly like to know what "empid" means,

My guess is Employee ID?

Regards

Roger Govier