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?
|