Hi,

I am trying to highlight a cell in red when all its content is already
contained in any of the cells above it.

I was recommended to use something like =COUNTIF(A:A,A1)1 , however
this seems to be looking for duplicate number values (with the 1). Am
I correct?

Essentially I need to say:

if the content of cell Ax is = to the content of any of the cells
A1:Ax-1, then highlight Ax in red

Is this possible?

JP


--
excelstart
------------------------------------------------------------------------
excelstart's Profile: http://www.excelforum.com/member.php...fo&userid=5881
View this thread: http://www.excelforum.com/showthread...hreadid=499209