countif(Range, Criteria) > 0

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

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
 
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.
 
Back
Top