How to automatically check for early identical entries?

[dori1]

Cheers everyone,

I am doing a translation and I am using Excel. There are two columns in my worksheet. Column A with the original text and column B with the translation. Every once in a while I run into a word I have translated before.

Is there anyway I could have excel checking if the value of cell A (x) is equal to a value A (1-x) (eg. A8) if so then fill cell B (x) with the corresponding value (eg. of the cell B8).

Perhaps it is a simple conditional formating but I can't figure out the formula.

Thank you.

D