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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Copy COUNTIF while retaining reference 7
countifs Function not giving desired result with date criteria 2
How to express a set of cells as a range 3
Match and Range Reference Syntax 3
Find last blank row and use in a formula 4
Excel VBA 1
COUNTIF criteria in VBA 4

Back
Top