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