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

See http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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

Thanks for your reply

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 i.e.if from above example list2 does not have
00010, it should display in column 3 as addition

Used =ColorIndex(A2) function but gives me a error Name#

any help will be appreciated

Thanks for looking into my query


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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