View Single Post
  #5   Report Post  
Ken Wright
 
Posts: n/a
Default

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?