Checking Duplicates in Google docs

[mr_mhackzz]

I am an encoder of ebay and we are using google docs to encode all sold items of ebay sellers.. I would like to ask if there is any format to check duplicate cell in google docs.. below is the format of the excel.

	F	G	H	I
E1			Hello kitty plush doll pink
E2			Transformer Megatron
E3		Duplicate (E1)	Hello kitty plush doll pink

<tbody>
</tbody>

In addition to that, If ever, If I put item names in Column H that has duplicate, the cell will turn into red cell.

Any response will be highly appreciated .