Highlight Duplicate text in multiple columns

[grcshekar]

Hi.

In the attached sheet, I have columns A to J. Requesting help to highlight duplicates in these columns please

[Pepe Le Mokko]

Select the range. Conditional formatting - Highlight cell rules - Click " duplcate values"

[Pete_UK]

Select all the cells from $A$1:$J$65, then click on Conditional Formatting | New Rule | Use a formula... , then enter this formula in the dialogue box which pops up:

=AND(A1<>"",COUNTIF($A:$J,A1)>1)

Click on the Format button | Fill tab and choose the colour that you want to use for the highlight, then OK your way out.

Hope this helps.

Pete