countif(Range, Criteria) > 0

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
 
T

Tom Ogilvy

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.
 

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

Using <= in countifs statement 1
VBA Coding Help for Beginner 0
countifs Function not giving desired result with date criteria 2
=Sumproduct Question 0
How to express a set of cells as a range 3
Combine 2 columns in a dynamic range into one 7
COUNTIF() 0
countif on multiple criteria 1

Top