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