countif(Range, Criteria) 0
 

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

countif(Range, Criteria) 0
 

Since you use relative addressing for A2, the formula should adjust.

Make sure you use absolute addressing in Range if you want to check the same
range.

--
Regards,
Tom Ogilvy

Steven wrote in message
...

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