How to highlight identical cell value of one column in another column?

[D_chapple]

Hi,

I have do some transaction over excel. In which I need highlight identical cell value of one column in another column.
Anybody has sound knowledge about the Microsoft excel? If yes then please let me the procedure to highlight identical cell value in two column.

[Macarenas]

Hi friends,

I think you should go for macro. If you don't know any excel macro to highlight identical cell value of one column in another column, don't worry please review following excel macro:

Sub exceltest()

Dim rngdemo As Range,, cfd As Range, a As Range, rngdemo1 As Range
Worksheets("block").Activate

Set rngdemo = Range(Range("D2"), Range("D2").End(xlDown))
Set rngdemo1= Range(Range("B2"), Range("B2").End(xlDown))

For Each a In rngdemo

Set cfd = rngdemo1.Cells.Find(what:=a.Value, lookat:=xlWhole)

If Not cfd Is Nothing
Then
a.Interior.ColorIndex = 4
Next c
End Sub

[ThoMas321]

Hi,

You need to apply some specific formula to each cell. The below excel formula will show whether cell value present in the other column or not:

NOT (IsError(vlookup
([cell value from list of first column],[cell value from list of second column],1,false)))

Try this excel formula and let know if your are successful in it or not.

[Sam.D]

Hi,

I am not expert in the Microsoft excel. But somewhere I read the formula to highlight identical cell value of one column in another column, and which is "IsNumber(match(Column 2nd,column1:0,1))".
And you will need to apply the this formula to those values for which you want to search the occurrence in the another column of the excel.