Hi Mr. Ken Wright,
What I want is not to highlight,but to get value/text in a cell(D1) where I
apply the formula.Suppose A1:A10 contains 10 values/texts (with some
repetitions) &B1:B10 contains the corresponding values/texts.I want to verify
the value/text of C1 in A1:A10 & to get corresponding value/text from
B1:B10,even though the value in C1 is a repeated one in BA1:A10.
Thanking you,
K.S.Warrier

"Ken Wright" wrote:

I'm a tad confused - If you don't want to highlight them and don't want
another column, where exactly do you want the data to be returned to, and in
what format?

Regards
Ken...........

"K.S.Warrier" wrote:

Thanks a lot Mr.Ken Wright.
I meant not simply highlighting.
K.S.Warrier

"Ken Wright" wrote:

Do you mean simply highlight them?

If so then select A1:B10, do Format / Conditional formatting, change cell
vaue is to formula is and put in =$A1<$B1

Now hit the format button, choose a nice pastel colour and hit OK until you
are out.

Regards
Ken....................

"K.S.Warrier" wrote:

Is there any formula to find the different(1st,2nd,3rd...) values in column
B(B1:B10) corresponding to repeated values in column A(A1:A10),without
creating another column?