Hi,

I am compiling a list with 3 columns and unlimited rows.

I need to avoid duplicate content by highlighting a cell in red if th
cell content is contained in any of the cells in its respectiv
column.

I have been trying with the if statement doing something like:

if:Ax=A1:Ax-1

I am not sure if the above synthax is correct, and how to highlight th
cell in red if the condition is true. Cell contents can be both number
and letters (spaces are allowed).

Can you help?

J

--
excelstar
-----------------------------------------------------------------------
excelstart's Profile: http://www.excelforum.com/member.php...nfo&userid=588
View this thread: http://www.excelforum.com/showthread.php?threadid=49828