I would like to use countif(Range, A2) 0 function, if my
statement is TRUE then color the cell backgroung yellow.

I would like to replace the A2 in the countif function
with the cell location so that I can copy the formula from
cell A2 to A1677.

Please me resolve this issue.

Thank You,

Steven