URGENT : Comparing 2 columns and highlight duplicate values only in the second column

[shadowknight]

Are there any ways to highlight duplicate values in the second column with and without using formula ?

Please reply as soon as possible

[Pete_UK]

You can use conditional formatting, and for that you will need to set up a formula.

Hope this helps.

Pete

[shadowknight]

please provide the steps. i need them to be higlighted only in the second column so that i can filter using color

[Pete_UK]

Select all the cells in column B, starting with your first cell (assume this is B1). Then click on Conditional Formatting | New Rule | Use a Formula... (at the bottom of the list), then put this formula in the dialogue box:

=COUNTIF(A:A,B1)>1

Then click on the Format button | Fill tab and choose your colour. OK your way out.

You don't say where your location is in your profile (please update), but you may need to use a semicolon instead of the comma in the formula.

Hope this helps.

Pete