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